Mail Merge to PDF

[Drew Burgess]

I want to create form letters to be sent to various entities. I have my
spreadsheet and I have the letter. I generally perform the mail merge, edit
the individual letters, copy and paste to create individual documents, then
save to PDF. This is a hassle. Is there an easier way to do this? I have
heard of the option to "Merge to Adobe PDF", or something like that. But this
button is not present.

 

[macropod]

Hi Drew,

To Merge to Adobe PDF, you'll need Adobe Acrobat Professional (v7 or later AFAIK) installed, on Word 2003 or later.

 

[Drew Burgess]

Hmm... So, basically, I have no options, then? (That is, other than to go
grab a load of cash and pay for the software...)

 

[macropod]

Hi Drew,

An alternative is to use an add-in or macro to split the merged document into separate files.

See: http://www.gmayor.com/individual_merge_letters.htm for examples of such utilities, and instructions on how to use them.