Mailing labels from spreadsheet

Writing a book, Automating Document Production - Discuss your special needs here

Mailing labels from spreadsheet

Postby thehobler » Fri Sep 10, 2010 4:50 pm

I have moved over from Microsoft Office. I know I should have an "Open" mind but my mindset is currently MS Office. I'm working hard to adapt. I'm simply trying to create mailing labels. The data is in an Open Office spreadsheet. The new document dialog box wants to know the "database" source for the addresses. This is where I would normally select my spreadsheet. It won't show me that option. Am I in the wrong place to create labels? This should not be so difficult. Help!

the hobler
Open Office 3.2 on Windows 7
thehobler
 
Posts: 3
Joined: Fri Sep 10, 2010 4:43 pm

Re: Mailing labels

Postby Hagar Delest » Fri Sep 10, 2010 4:59 pm

Hi and welcome to the forum!

See perhaps that query, there are plenty topics about mail merge.

Please add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.
AOO 4.0.1 on Windows 7 and Xubuntu 14.04 (Trusty Tahr)
User avatar
Hagar Delest
Moderator
 
Posts: 25088
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Mailing labels

Postby JohnV » Fri Sep 10, 2010 5:03 pm

You need to register your spreadsheet as a data source. Step through File > Wizards > Address Book Data Source and it will then be available in the Label's database box drop down menu.
JohnV
Volunteer
 
Posts: 1509
Joined: Mon Oct 08, 2007 1:32 am
Location: Kentucky, USA


Return to Advanced Uses

Who is online

Users browsing this forum: No registered users and 2 guests