Mail Merge - works but need info

Discuss the word processor
Post Reply
starla17
Posts: 2
Joined: Tue Sep 12, 2017 6:57 pm

Mail Merge - works but need info

Post by starla17 »

I successfully executed mail merge and now have multiple letters printed to text files, with all the correct information in it. However, the information is not embedded (or fixed? I'm not sure the right word to say here) to the text file. Instead, it is highlighted in grey, and the data in it us not editable. I need to send the files to someone else so they can fine tune the information, which may include editing the information I put in the file using the mail merge. How do I do the mail merge so the data is fixed to the text document when I print to file, instead of a field connected to the spreadsheet still? Thank you!
OpenOffice 4.1.1
Mac OS X El Captain
Version 10.11.6
starla17
Posts: 2
Joined: Tue Sep 12, 2017 6:57 pm

Re: Mail Merge - works but need info

Post by starla17 »

I think I need to select the "data to text" icon when I am printing to individual files, but I can't click on it. Help please! :)
OpenOffice 4.1.1
Mac OS X El Captain
Version 10.11.6
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Mail Merge - works but need info

Post by Villeroy »

Print the letter.
Confirm that you are going to print a form letter (aka serial letter, aka mail merge).
Choose "File" as output.
In the resulting files the grey fields (place holders) are replaced with text.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply