Hi Team,
As we are aware, when we perform a mail merge and preview the letters, the multiple records get printed into a single document.
I have the below macro that saves each individual record separately on my desktop in a Mail Merged Folder.
My Concern - The macro would now be used on many users desktop and as you can see I have my desktop path in the macro that would affect the macro if used on other users desktop.
What I need -
1. I want the macro to automatically create a folder on the users desktop as "Merged Docs" and direct the macro to save all the docs in that path.
2. The macro currently saves each document as "Merged1", "Merged2", "Merged3"........... I would like the file name to be saved as per column A (Employee Number) on my excel list used for mail merge.. So that the word docs are saved as "1000000", "10000002", "10000003"......
Thanks in advance.
Bookmarks