Hi,

I'm sorry if this is a repost. I've literally spent 90 minutes googling how to do this and I got as far as saving the first mail merge 25 times - I think the macro I used wasn't designed for mail merges.

I'm mail merging letters but need to save each letter as it's own pdf. The letters all have the same file name e.g. 20140528 - Letter.pdf but are all saved in different locations.

I'm trying to create a macro that splits the mail merge and prompts me to select the save location for each pdf.



Any help is greatly appreciated

There are literally oodles of discussions of this kind of thing on the web and detailed instructions on multiple websites. See, for example 'Split the single merged document into separate letters' at: http://www.gmayor.com/individual_merge_letters.htm

IMHO, though, you'd do better to tackle the problem at the source. In addition to the alternatives in the link, see also: https://www.msofficeforums.com/word/...documents.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]