Small application which allows to repeatedely replace markers in a Microsoft Word document with items taken from a CSV/Microsoft Excel file to provide a simple mail-merge functionality
Currently, if the replacement-tags span multiple formats, replacement is simply not done, because we look at a run at a time. There are multiple options to handle this better:
detect incorrectly formatted tags and fail gereation
detect an unclosed tag and include text from the next run in this case
There is a fork which implements writing the result to separate files at https://github.com/jedwards36/poi-mail-merge, we could incorporate this in the main version via a commandline option.
Is there any way to set the page size for the document? Because, the generated document has the merged documents mixed up with the previous one. I have attached the screenshot for this.
The one issue I have is that I am merging dates which are in Australian format (i.e. dd/mm/YYYY) from my .xlsx spreadsheet and they are somehow being transformed to US format (i.e. mm/dd/YYYY) in the 'filled' .docx. I could care less about the YYYY vs. YY output, but the inversed day/month characters are a bit of an issue!
Any ideas how I could fix this? I have ensured that both input and output merge fields (in Excel/Word) are formatted to dd/mm/YYYY and that my system (Debian 9) is set to English AU keyboard/time/geo options but I ran out of idea there.