LibreOffice Mail Merge Printing

This is how to print a document which has had the mail merge fields put into it and already had the database created from a spreadsheet.  I'll document that part someday, but this is what I did today.

I did it on LibreOffice, but I'm guessing it also applies to old OpenOffice too.

I got all this stuff from this 10 minute video, but sometimes you can't wait 10 minutes!
http://www.youtube.com/watch?v=prZJ4w-q9AA

1. Open document you've already put the database fields into.
2. Print to a file:
   File/Print - pop up should appear "Your document contains address database fields.  Do you want to print a form letter?" You do so press 'Yes'
   *Possible Warning Popup see Check Connection Settings Below*Output/File (not the printer default) / Save as single document / OK
3. Save as Type 'pdf'/ enter filename / save
4. You now have a PDF that you can print.

Job done.

Check Connection Settings

But what if you had a popup with the option to 'Check Connection Settings' with the text:

"The data source "PresentsDB" was not found. Thus the connection to the data source could not be established.  Please check the connection settings"

This means that LibreOffice does not know where to get the data from.  So you need to register the database on this machine.  To do this:

1. Press the 'Check Connection Settings' button on the popup.
2. Register the database:
   New... / Browse to your .odb file /open
   The registered name should appear, hit OK
   The db should now be registered, hit OK.
3. Now try printing again :-)