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