Ask Your Question
0

Printing mail merge to separate pdf files results in identical documents

asked 2015-08-17 16:49:01 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have created a document with mail merge fields. I click print, it asks me "Your document contains address database fields. Do you want to print a form letter?" I choose yes. I choose all records, output as file, save as individual documents, generate file name from database, "account number" field as the file name, the correct file path, and PDF as the file format. When I click "ok" it exports three pdfs (that's the number of lines in my test database) with the correct file names (Account Number 1, Account Number 2, Account Number 3), but once I open the pdfs, I find that all three are identical, containing the customer name, account number, and expiration date from only the first line in my database. I desperately need to export this test document properly with the mail merge fields filled, as separate PDF documents named automatically based on the account number field. And I need to figure it out by end of day tomorrow! HELP!

edit retag flag offensive close merge delete

Comments

Please add which version of LibreOffice you use and what kind of database.

Regina gravatar imageRegina ( 2015-08-17 21:37:39 +0200 )edit

I have tested this with LibreOffice dev 5.1 (current trunk) and a database from spreadsheet, on Windows 7. It works fine here.

Regina gravatar imageRegina ( 2015-08-17 21:44:34 +0200 )edit

I am having the exact same problem. Using LibreOffice 5.0.2.2 running on Ubuntu 15.10. The mail merge is an all-LibreOffice operation - ODT for the main document, ODS for the spreadsheet containing the data, ODB for the connection database. This worked perfectly the last time I did this using the same files (except for 2 new records added for a total of 187). It works correctly when printing - just not with PDF. Every file contains data from the first record in the spreadsheet.

StephenMcGehee gravatar imageStephenMcGehee ( 2016-01-07 03:58:31 +0200 )edit

I have the exact same problem to. Using LibreOffice 5.0.3.2 on Windows 10. The PDF documents have different names from the database (116 names), but when opened the documents are identical. I will try to upgrade - see if that helps. When merging to individual ODT documents everything works fine.

Update: Installing the newest 5.0.4.2 did not help.

Einar Hals gravatar imageEinar Hals ( 2016-02-01 12:28:33 +0200 )edit

"This worked perfectly the last time I did this using the same files (except for 2 new records added for a total of 187). It works correctly when printing - just not with PDF. Every file contains data from the first record in the spreadsheet."

Same problem LibreOffice 5.0.4.2 00m0(Build:2) SUSE 13.2

pwschuck gravatar imagepwschuck ( 2016-05-11 16:41:41 +0200 )edit

Please Libre Office Team! Same problem here. - I have for two years used this function - Printing a mailmerge document with fields from my database. It works fine when printing on paper, but on choosing file - Individual files as Output I only get the first record in my Query - and not the chosen post. This applies weather I choose ODT, Word or pdf files. I tried installing an other version of the Libre Office package and different country versions; but only to get the same result. This might ha

Ortopedersen gravatar imageOrtopedersen ( 2016-09-02 09:51:24 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2018-05-29 00:08:43 +0200

Has this been fixed? (I'm still on devuan jessie with LO 5.4)

edit flag offensive delete link more
0

answered 2016-05-11 17:07:25 +0200

Short term hack solution:

print them as individual LibreOffice documents then apply:

libreoffice --headless --convert-to pdf *.odt

-- Pete

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-08-17 16:49:01 +0200

Seen: 1,132 times

Last updated: May 29 '18