[Solved] Mail Merging more than a simple address block

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

[Solved] Mail Merging more than a simple address block

Postby tadiv » Mon Oct 22, 2018 2:59 am

I'm trying to generate mail merge invoices. Of course they will have the standard address blocks, but they will also have balance due, various credits, debits, and account info. The stock offerings in the mail merge wizard dies not seem to allow much more than the standard address block, greetings, and salutations. How can I get more data merged into a form?

Thanks,
Tom
Last edited by Hagar Delest on Thu Nov 01, 2018 6:05 pm, edited 1 time in total.
Reason: tagged solved
OpenOffice 4.1.3 on Windows 8.1
tadiv
 
Posts: 4
Joined: Mon Oct 22, 2018 2:50 am

Re: Mail Merging more than a simple address block

Postby John_Ha » Mon Oct 22, 2018 10:31 am

As a 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.

See Chapter 11 - Using Mail Merge. You need three things:

1 A spreadsheet .ods containing all the data to ber merged
2 A database .odb file which acts as the interface - it MUST be registered
3 A text document .odt into which you wish to merge everything.

Or search the forum with mail merge.

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.
John_Ha
Volunteer
 
Posts: 6649
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Mail Merging more than a simple address block

Postby tadiv » Mon Oct 22, 2018 10:41 am

Thank you!
Tom
OpenOffice 4.1.3 on Windows 8.1
tadiv
 
Posts: 4
Joined: Mon Oct 22, 2018 2:50 am


Return to Advanced Uses

Who is online

Users browsing this forum: No registered users and 1 guest