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!
Please add which version of LibreOffice you use and what kind of database.
I have tested this with LibreOffice dev 5.1 (current trunk) and a database from spreadsheet, on Windows 7. It works fine here.
I am having the exact same problem. Using LibreOffice 18.104.22.168 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.
I have the exact same problem to. Using LibreOffice 22.214.171.124 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 126.96.36.199 did not help.
“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.”
LibreOffice 188.8.131.52 00m0(Build:2)
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
Short term hack solution:
print them as individual LibreOffice documents
libreoffice --headless --convert-to pdf *.odt
Has this been fixed? (I’m still on devuan jessie with LO 5.4)