Mailing Labels

Discuss the spreadsheet application

Mailing Labels

Postby glp103 » Wed Dec 19, 2007 4:22 am

I have a spreadsheet originally created with Microsoft Excel with several columns including Name , Address , City, Zip and others. Is there a way to make mailing labels from the addreses? I have no other data program with this information.
glp103
 
Posts: 3
Joined: Wed Dec 19, 2007 4:09 am

Re: Mailing Labels

Postby acknak » Wed Dec 19, 2007 6:40 am

Try File > New > Labels and see how it goes. Don't give up if you get stuck--it takes some effort to get it to work. If you run into a problem, just ask.

You may also want to read the "Mail Merge" Chapter of the Writer Guide.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Mailing Labels

Postby JohnV » Wed Dec 19, 2007 7:17 am

Before you do as acknak suggests you must register your Excel file as a data source. Do File > New > Database, bullet Connect to Existing Database, select Spreadsheet from the drop down menu and complete the wizard.
JohnV
Volunteer
 
Posts: 1585
Joined: Mon Oct 08, 2007 1:32 am
Location: Kentucky, USA

Re: Mailing Labels

Postby acknak » Wed Dec 19, 2007 7:51 pm

So sorry, I thought the "Labels wizard" would take care of that step. Thanks, JV.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3


Return to Calc

Who is online

Users browsing this forum: No registered users and 27 guests