Ask Your Question
0

Mail Merge: can I include a database field in the file name?

asked 2016-10-21 22:58:01 +0200

Tilman gravatar image

I want to include a database-field when saving mail merge results to individual files.

I have read references to ticking an option "Generate file name from database" in the mail-merge wizard - However I don't find any such option in LibreOffice Version 5.1.0.3.

  • Has it been removed?
  • Is there a secret syntax to refer to database fields in the file-name selection dialog?
edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2016-10-22 13:38:04 +0200

pierre-yves samyn gravatar image

Hi

You can use FilePrint to do you mail merge.

  • Writer asks: You document contains address database fields. Do you want to print a form?Yes
  • Output: File
  • Save Merged Document: Save as individual documents
  • Tick Generate file name from database
  • Select the field to use

Regards

edit flag offensive delete link more

Comments

Great, thanks for the hint - didn't know the functionality was available from there as well! I had to update LibreOffice to avoid a crash when saving the merged documents.

Unfortunately, when saving to PDF there, hidden paragraphs are not hidden before saving.

Workaround: First save to ODT, then use loffice --convert-to pdf *.odt.

Tilman gravatar imageTilman ( 2016-10-22 21:50:32 +0200 )edit

What a pity this vital function is hidden under the print menu rather than on the Mail Merge Save menu where it rightfully belongs

mymsman gravatar imagemymsman ( 2019-07-02 21:15:27 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-10-21 22:58:01 +0200

Seen: 629 times

Last updated: Oct 22 '16