I have a table of addresses in writer (odt) and am having trouble producing labels. In particular, how do I get the text document table to appear in the Labels dialogue box - database field etc.
Hi
You can not directly use table of a Writer document as a mail merge source. The solution is either to copy and paste the table in a Calc spreadsheet, or:
- convert the table to text:
Table▸Convert▸Table to Text - save the document in text format:
File▸Save As▸Type(listbox):Text (.txt) - use
Edit▸Exchange Databaseto select the txt file (a database is created is created that stores field separator, text delimiter, and so on).
Regards
Hi
Thanks for your advice. However, the problem is the same in calc. File/Labels gives a dialogue box for selecting the fields. That dialogue includes a heading for ‘Database’ to select to use for the fields and data. But the drop down box is empty; how does one get (navigate to) the required data document (calc spreadsheet) into that drop down?
You can use Edit▸Exchange Database to select the spreadsheet then the sheet then Define, or you can create and register a database connected to the spreadsheet. These two techniques are explained in this FAQ