OpenOffice macro to make text-file usable as database
Posted on 2011-03-20
I don't know much about OpenOffice, but now I need to know a lot!
I need to use an output form one program (text file) as a database for adresses in a standard letter merge in Writer.
The output is a standard text-file containing a lot of addresses. Each address is 6 lines.
I hve to transform this six line address into something like a CSV file: 6 fields per address, semicolon as delimiter, preferrably contained in quotes - all neatly presented in one line per address.
And the solution has to be fool proof. The user, that will be using this on a monthly basis, knows just enough to folow a guide on how to do the merging from a template. So this has to be done almost automatic.
How do I solve this??