Hi!

I've created a mailmerge for about 20 different Word documents that all use the same data from my single data sheet. Currently, I have to go into each Word document and save the mailmerge as a PDF. This is fine but gets tiring when it needs to be done 20 times.

I've tried to automate this with VBA however when I open the Word document using VBA, it does not recognise it as being mailmerged and only opens the template file, which makes the whole mailmerge pointless. The mailmerge link is just removed.

Does anyone know why VBA does not open the mailmerged documents and if this can be fixed?

Are there even any other, better ways to automate the creation of 20 documents all using data from a single excel sheet?

For info, each document is just a clients personal information and using a mailmerge is just quicker than copying/editing/amending each document!

Many thanks for any help.



Fred