Good to hear your having some success... > 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). You can actually map the fields to ones in your data source (or spreadsheet in your case). When your at the "insert address block" select the 'match fields' button. This will bring up a box which allows you to assign each of the address block entries to specific fields within your data source.
The 'more' setting (next to the design of the address block) also allows you to use one of the pre-set address blocks, but also to design your own address block. Although you are forced to use OOo "address elements" there is nothing to say that you can't then assign your own data to that field. For instance, here in Kiwi land, we have postcodes, not zip's. Therefore my data field 'postcode' would be mapped to address element 'zip' and then included in the address block... Reply to the list if further assistance is required... /paul On 7/7/05, Greg Bulmash <[EMAIL PROTECTED]> wrote: > 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]
