Printing Address Labels for mailout

Discuss the spreadsheet application
Post Reply
User avatar
Tuiruru
Posts: 53
Joined: Wed Sep 02, 2009 2:17 am

Printing Address Labels for mailout

Post by Tuiruru »

Hi

A community organisation I do voluntary work for was to do a mailout and has the names and addresses of members in an excel (circa XP, Office 97/2003 vintage)spreadsheet.

Is there a way of pulling this into Calc and printing the names and addresses onto pages of sticky back (Avery type) labels? (they've been writing over 250 envelopes by hand :shock: )

Many thanks
OpenOffice 3.1.1 on Windows Vista Home Premium
JohnV
Volunteer
Posts: 1585
Joined: Mon Oct 08, 2007 1:32 am
Location: Kentucky, USA

Re: Printing Address Labels for mailout

Post by JohnV »

Open the spreadsheet with Calc and do a Save As to .ods format. Register the new file as a data source (File > Wizards > Address Data Source).

Do File > New > Labels and the new data source should show up in the Datebase box drop down menu, same for its Table(s) and fields. On the Options tab check Synchronize and when you do New Document any edit you do to the top left (Master) label can be pass on to the other labels by clicking Synchronize.

To print click the Print icon and answer 'yes' to the 'form letter' query.
User avatar
Tuiruru
Posts: 53
Joined: Wed Sep 02, 2009 2:17 am

Re: Printing Address Labels for mailout

Post by Tuiruru »

Thanks for that JohnV

I'm assuming they've been sensible and got the data set out so that each item is in a seperate column (First Name, Last Name, Number and Street, Town, etc).

Does that need the first row to have headings in it, and if so does that row have to have any special formatting?

Have you any other advice before they get too far down the track? (I'm afraid this is a case of "I know it's possible, but I've never actually done it" ;) )
OpenOffice 3.1.1 on Windows Vista Home Premium
thomasjk
Volunteer
Posts: 4451
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: Printing Address Labels for mailout

Post by thomasjk »

Yes the first row should have the headings(Field Names). No special formatting needed. See this excellent article for some help http://www.freesoftwaremagazine.com/art ... office_org. Its old but still applicable.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
User avatar
Tuiruru
Posts: 53
Joined: Wed Sep 02, 2009 2:17 am

Re: Printing Address Labels for mailout

Post by Tuiruru »

thomasjk wrote:Yes the first row should have the headings(Field Names). No special formatting needed. See this excellent article for some help http://www.freesoftwaremagazine.com/art ... office_org. Its old but still applicable.
Thanks very much Tom - that's just the sort of thing I was looking for, along with the other links it contains :super:
OpenOffice 3.1.1 on Windows Vista Home Premium
NiallMartin
Posts: 12
Joined: Sun Nov 15, 2015 12:12 am

Re: Printing Address Labels for mailout

Post by NiallMartin »

There are instructions on the website in which you are asked to simply create the page, setting the names of the columns you need for your label, save the document and then merge the result. the method given to the first poster makes sense and I'll try it.
Niall Martin
OpenOffice 4.1.3
Win 10
NiallMartin
Posts: 12
Joined: Sun Nov 15, 2015 12:12 am

Re: Printing Address Labels for mailout

Post by NiallMartin »

file not found.
Niall Martin
OpenOffice 4.1.3
Win 10
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Printing Address Labels for mailout

Post by Villeroy »

Spreadsheet with or without header. No special formatting.
File>New>Database...
Connect to existing DB of type "Spreadsheet"
Point to the spreadsheet which contains your list.
[X] Register database
Save the database
Close and forget the database. It is just a link to your spreadsheet. Nothing has been converted, imported nor copied.
Writer menu:File>New>Labels
Follow the wizard and refer to the database.

When you print the label document, you will be asked if you are going to print a serial letter. Answer "Yes".
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
NiallMartin
Posts: 12
Joined: Sun Nov 15, 2015 12:12 am

Re: Printing Address Labels for mailout

Post by NiallMartin »

Still not there. I merely get a page of cards showing the field names but not their contents.
Niall Martin
OpenOffice 4.1.3
Win 10
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Printing Address Labels for mailout

Post by Villeroy »

And when you hit Ctrl+P (File>Print)?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
NiallMartin
Posts: 12
Joined: Sun Nov 15, 2015 12:12 am

Re: Printing Address Labels for mailout [solved]

Post by NiallMartin »

Had missed the prominent arrow in the set up dialogue to set up the database fields on the labels.

Problem solved with thanks
Niall Martin
OpenOffice 4.1.3
Win 10
Post Reply