View Single Post
 
Old 08-04-2017, 03:38 AM
dushan997 dushan997 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Aug 2017
Posts: 2
dushan997 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
That makes having a macro rather pointless, since the user has to open & configure the mailmerge main document before they can use it (including adding any mergefields, filters, etc. - which requires connecting to the data source) and, once they've done that, they may as well complete the merge then & there.
Thank you so much for your valuable time taken for this.

Actually the templates are not varying over time. They have only 3 fixed templates. Think of these as standard certificates for a school. And the data source is the same for all three, although I made it slightly flexible by loading data sources to a different drop down.

Only that they need to choose one out of three templates each time. So initially the admin can do a manual mail merge to generate these three templates and save them in a directory so that the user does not have to go though the process again.

It is for saving time and to reduce complexity for non IT users.

Last edited by dushan997; 08-04-2017 at 03:39 AM. Reason: Thanking the user
Reply With Quote