Paul wrote:
I've just done this (not having done it before) in 1.9.109 - it took
about 10-15 minutes. I used a calc spreadsheet with first row as
headings, just as you mentioned. Admitedly it took a little longer to
extend this so that the body of the text could include variables from
the spreadsheet - but it was all doable...
Interesting to hear why you think this was hard or impossible to do...
Because I tried. But got frustrated at the "Address Block" section,
unaware that I was only being forced into pre-defined fields there.
After further exploration (and your claim it could be done), I figured
out how to do it from a spreadsheet.
You can certainly use an calc spreadsheet (haven't tried .odt table).
Tried .odt table, the insert fields function wouldn't interpret it.
Sort of a bummer there since inserting multi-line data in a spreadsheet
cell requires hitting ctrl+enter for a line break, and if you forget the
ctrl, there are unintended consequences. Other than that, once I found
out where things were, it wasn't difficult to do a mail merge.
There is nothing special needing to be done - simply select the calc
spreadsheet as the source of the mail merge.
And create the address block manually in the document, ignoring the one
in the wizard (unless you're using the exact same field names it does, I
guess). It was the address block step in the wizard that became my
stumbling point and great source of frustration because it didn't look
like I could import data from my spreadsheet.
My mistake.
- Greg
--
"Those computer manuals would be easier to understand if they used words
like thingy and whatzit like normal people do." - Greg's Mom circa 1991
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
