Ask Your Question
0

How do I create labels from a table in Writer

asked 2016-12-13 11:46:34 +0100

terry10k gravatar image

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.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2016-12-13 13:57:39 +0100

pierre-yves samyn gravatar image

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: TableConvertTable to Text
  • save the document in text format: FileSave AsType (listbox): Text (.txt)
  • use EditExchange Database to select the txt file (a database is created is created that stores field separator, text delimiter, and so on).

Regards

edit flag offensive delete link more

Comments

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?

terry10k gravatar imageterry10k ( 2016-12-13 15:16:43 +0100 )edit

You can use EditExchange 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

pierre-yves samyn gravatar imagepierre-yves samyn ( 2016-12-13 15:30:17 +0100 )edit
0

answered 2016-12-16 13:48:16 +0100

JohnHa gravatar image

See full instructions in the manual at https://www.libreoffice.org/get-help/...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-12-13 11:46:34 +0100

Seen: 424 times

Last updated: Dec 16 '16