Ask Your Question

I have a text list of 160 names and addresses. How do I format it and print on Avery 5660 labels without having to enter each name and address in a new spreadsheet?

asked 2016-12-05 23:20:20 +0200

Tom Lehner gravatar image

I have Libre Office 5.1

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-01-03 15:49:15 +0200

JohnHa gravatar image

Read the manual - it is fully described there.

edit flag offensive delete link more

answered 2016-12-06 11:24:13 +0200

Lupp gravatar image

updated 2016-12-06 11:42:14 +0200

If your data (names and addresses) are well structured it should not be a problem to get them into a table in 'Writer' using > 'Table' > 'Convert' > 'Text to Table...'. This table you may copy and insert into a new 'Calc' spreadsheet without any typing. The spreadsheet you can use as the data source when defining the 'Writer' document for printing labels using the > 'File' > 'New' > 'Labels' tool.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools


Asked: 2016-12-05 23:20:20 +0200

Seen: 156 times

Last updated: Jan 03 '17