Mail Merge with Template Choice

[CutAndPaste]

I want to set up a Mail merge (actually just a single record) from an Access form. When the routine runs I want the "Choose Template" dialogue to open so that the user can choose which standard letter to use.

I know that the Templates should be set up with "BookMarks" that can be filled in from Access but how to string this together is a bit beyond me.

Any ideas or relevant threads please.

thx

 

[Fornatian]

Assuming that your letters use the same table or query as the datasource I would approach this as follows:

1. Set up a table to hold the paths to the relative standard files.
2. Use the table as the source for a listbox.
3. When the user clicks a record in the listbox and clicks the 'Go' button you've added, use

Application.FollowHyperlink Me.MyListBox

which will cause the chosen file to open.

4. Having set the documents up in word to automatically merge with your datasource there is no need to worry about outputting files etc..

if you letters use different datasources then that is slightly different in that you need to merge the documents with the different sources first.