I need to set the datasource for a set of mail merge documents to deploy to users on and off the LAN and may have updates each month.
To save remoting and resetting up datasources etc... (and also guessing the location) I want to set the datasource location on load or via button.. probably both.
Will use a specifically named file in the downloads directory of the current user.
Please supply a routine that will change the datasource. Please put XYZ as the path and I will generate etc...
The experience is:
User opens the document... it does it then and then merges... AND .. can be done via button to do an update.
OK.. seems as though this is a starting point:
And . Execute if you want to mail merge as part of the routine
Any additional suggestions?