We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Mail merge not printing [closed]

asked 2018-04-26 22:56:01 +0200

GeorgeH gravatar image

updated 2020-08-30 23:56:09 +0200

Alex Kemp gravatar image

If I try and print mailmerge either to a file or to the printer neither works.

Saving to a file - A filename is requested, but no file is created.

Printing a standard document - Works fine

Printing a mailmerge = No printer dialogue box appears to select number of copies or other details and nothing gets printed.

"Use OpenGL" and "ForceOpenGL" are both unchecked (which was the solution to the similar Q61106).

Libre Office (just uploaded the latest version) on Ubuntu 16.04 LTS.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-30 23:56:30.428746

2 Answers

Sort by » oldest newest most voted

answered 2018-05-03 15:41:22 +0200

GeorgeH gravatar image

The correct procedure seems to be as follows

  1. Open the document
  2. Press F4 for data sources, and select the required Table (NOT Query)
  3. select any record
  4. press “Data to Fields”
  5. Print, and accept Yes to mail merge
  6. NOW select the required Table or Query on the mail merge screen, and select the required records
  7. Print.

Step 4 seems to be the crucial step, even for existing merge documents. Step 3 is necessary to enable step 4.

edit flag offensive delete link more

answered 2018-08-30 22:30:15 +0200

I'm on Mac Os X 10.13.6 with LibreOffice JDK 10.2 and MySQL connector 8.0.12.

Using the above procedure does not work. I deleted the preferences folder for LO and reconfigured but get the same result. Base has no problem connecting to MySQL.

BUT the mail merge fails. Print shows 123 records to merge. All I get is one page with no data merged. I recently updated LO but this was working several months back.

I only use it 4 times a year to print labels for our magazine.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-04-26 22:56:01 +0200

Seen: 791 times

Last updated: Aug 30 '18