Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 08-04-2017, 03:38 AM
dushan997 dushan997 is offline Choosing Mail Merge templates and excel Data Sources using drop downs Windows 7 64bit Choosing Mail Merge templates and excel Data Sources using drop downs Office 2013
Novice
Choosing Mail Merge templates and excel Data Sources using drop downs
 
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
 

Tags
mailmerge, vba, word development



Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop Downs Suray1911 Excel 1 09-29-2015 10:31 PM
how NOT to start word 2013 with 'choosing templates'? dylansmith Word 4 12-08-2012 12:59 PM
Choosing Mail Merge templates and excel Data Sources using drop downs Templates, pictures, Mail Merge and Excel kckay Word VBA 1 05-17-2012 08:51 PM
Choosing Mail Merge templates and excel Data Sources using drop downs Please help me with drop downs in Excel 2010 mhays Excel 6 01-16-2012 09:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:26 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft