Mail Merge Addresses from Calc

Discuss the word processor

Mail Merge Addresses from Calc

Postby Albionninoz » Wed Jul 11, 2018 10:01 am

Hi, I have an address list in Calc but want to print address labels. I believe the best way is from Writer but I can't seem to find how to import my data from Calc into Writer. Or is there another way? Would I have to create a database in Base and how would I do that? Thanks in advance.
Cheers, Ray
OpenOffice 4.1.4
Windows 7
Posts: 4
Joined: Thu Dec 28, 2017 7:03 am

Re: Mail Merge Addresses from Calc

Postby robleyd » Wed Jul 11, 2018 10:34 am

A search of the forum would turn up a number of topics on the subject, including this one which should point you in the right direction.
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
Posts: 2643
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Mail Merge Addresses from Calc

Postby John_Ha » Wed Jul 11, 2018 11:35 am

As a relatively new poster you will find much useful information in the Writer FAQ, the Writer Tutorials, the up to date Writer guide and the Writer Manual. May I suggest you bookmark the pages.

Mail Merge is covered in Chapter 11.

Press F1 to access the Help screen and search for your problem

The chapter headings in the manual are:

1 - Introducing Writer
2 - Setting up Writer
3 - Working with Text
4 - Formatting Pages
5 - Printing, Exporting, Faxing and E-Mailing
6 - Introduction to Styles
7 - Working with Styles
8 - Working with Graphics
9 - Working with Tables
10 - Working with Templates
11 - Using Mail Merge
12 - Tables of Contents, Indexes and Bibliographies
13 - Working with Master Documents
14 - Working with Fields
15 - Using Forms in Writer
16 - Customizing Writer – Keyboard shortcuts.

When a pop-up window opens, click the Help button for extensive help on that function - it is often more comprehensive than the manual.

Showing that a problem has been solved helps others searching so, if your problem is now solved, please view your first post in this thread and click the Edit button (top right in the post) and add [Solved] in front of the subject.
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Posts: 6593
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Return to Writer

Who is online

Users browsing this forum: No registered users and 17 guests