Mail merge to address labels from XL spreadsheet

Talk about anything at all....
Post Reply
kenyonart
Posts: 1
Joined: Wed Apr 28, 2010 8:46 pm

Mail merge to address labels from XL spreadsheet

Post by kenyonart »

Hey,
I got and address list set up on excell spreadsheet. I can only open it by rightclicking and going to>open with>openoffice.org.calc

Then it's "read only" I think because the sender did it for microsoft word.

I want to set it up on address labels (columns G,H,I,J,K) (street,town,state,zip,name)

I downloaded the Avery 5160 template from pg 24 of the templates page at openoffice.org

I bought the 8160 labels from Avery, compatible with that template.

Still can't seem to figure out hoew to merge from the spreadsheet on to the template, Can anyone walk me thru it?????

I'm not terribly computer literate.

Thanks, Brian
Open office 3.2
Windows PC
thomasjk
Volunteer
Posts: 4451
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: Mail merge to address labels from XL spreadsheet

Post by thomasjk »

I recommend this article http://www.freesoftwaremagazine.com/art ... office_org. The Avery 5160 labels are built into OOo. See also http://openoffice.blogs.com/openoffice/labels/ for more help.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
Post Reply