Am Dienstag, 25. Oktober 2005 18:50 schrieb Matej Cepl: > Guido Pinkernell wrote: > >> I understand how to make in OOWriter mail merge letter (aka form letter > >> in OOoese; all this is about OOo 1.1.4 -- I am currently waiting when > >> OOo 2.0 will be available for Debian/testing, so bear with this old > >> version) using datafields from OOCalc. However, I haven't found a way > >> how to attach data from a spreadsheet (imported from Excel) to the > >> already existing mail merge letter (imported from Word) -- in other way > >> how to do mail-merge on the pair of mail merge letter/spreadsheet > >> originally from M$-Office? > > > > I would expect the procedure of reattaching a data source to be the same > > as attaching a data source. So please check manuals or howtos on mail > > merge for OO.org 1.1.4 at http://documentation.openoffice.org/index.html > > Sorry, this doesn't work -- all documentation seems to be meant for > creating new mail merge letter from scratch so I haven't found a way how to > re-assign different data source (and I will need to mail-merge some twenty > or so different spreadsheets to one Word template).
Here I am again. I haven't read through all documentation so I can't tell what it says exactly. Here is what I did with 1.1.4 (and still do with 2.0): Open the Writer doc. Press F4 to open datasources. On top of the doc a new window opens with a list of available sources. Choose the one you need, then choose the table you need. On the right this table opens. Delete the fields in the Writer doc and replace them with new. Like this: For each field select the appropriate column in the table and drag it to the place in Writer doc exactly where its contents should appear. I hope this helps. Guido --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
