Merging fields

[Perfac]

Our accounting package will be used by customers from where we host it. We try to protect the BACK END or don’t want customers to see the design of the fornt end. When I use Mail merge for standard documents and open such a Word document, I click on a command button(See the attachment for the VBA that opens hat word document . I click on Mail Merge in word and then have to click on MAIL RECIPIENTS and have to see the back end to choose the source. "Edit Recipient List" is not available before the source is selected. Can I set that?

Is there a way to set the source so that there is no need to see our BACK END. Or is there another way I can merge fields to a word document for standard letters?

[isladogs]

Try Albert Kallal's 'super easy mail merge' which is exactly what it says.
Its many years old now but is still in use by large numbers of people
Available from many places including: http://hitechcoach.com/downloads-mai...asy-word-merge

All the mail merge code is done within Access which makes life ... super easy

[Gicu]

I use a similar approach, I use a query to get the data I want to use for the merge, export it to a csv file using docmd.transfertext then use that as the mail merge source. That way the Word mail-merge template doesn't interact with Access at all.

Cheers,
Vlad