Printing Address Labels for mailout

Discuss the spreadsheet application

Printing Address Labels for mailout

Postby Tuiruru » Mon Jun 20, 2011 12:29 am

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
User avatar
Tuiruru
 
Posts: 53
Joined: Wed Sep 02, 2009 2:17 am

Re: Printing Address Labels for mailout

Postby JohnV » Mon Jun 20, 2011 2:52 am

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.
JohnV
Volunteer
 
Posts: 1585
Joined: Mon Oct 08, 2007 1:32 am
Location: Kentucky, USA

Re: Printing Address Labels for mailout

Postby Tuiruru » Mon Jun 20, 2011 6:31 am

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
User avatar
Tuiruru
 
Posts: 53
Joined: Wed Sep 02, 2009 2:17 am

Re: Printing Address Labels for mailout

Postby thomasjk » Mon Jun 20, 2011 6:56 pm

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
thomasjk
Volunteer
 
Posts: 4408
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: Printing Address Labels for mailout

Postby Tuiruru » Mon Jun 20, 2011 10:01 pm

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
User avatar
Tuiruru
 
Posts: 53
Joined: Wed Sep 02, 2009 2:17 am

Re: Printing Address Labels for mailout

Postby NiallMartin » Tue Sep 27, 2016 7:03 pm

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

Postby NiallMartin » Tue Sep 27, 2016 7:19 pm

file not found.
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

Postby Villeroy » Tue Sep 27, 2016 8:14 pm

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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27084
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Printing Address Labels for mailout

Postby NiallMartin » Tue Sep 27, 2016 9:35 pm

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
NiallMartin
 
Posts: 12
Joined: Sun Nov 15, 2015 12:12 am

Re: Printing Address Labels for mailout

Postby Villeroy » Tue Sep 27, 2016 9:41 pm

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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27084
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Printing Address Labels for mailout [solved]

Postby NiallMartin » Wed Sep 28, 2016 3:31 pm

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
NiallMartin
 
Posts: 12
Joined: Sun Nov 15, 2015 12:12 am


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 16 guests