I have an MDB where I have initiated a mail merge in a button. The user clicks, selects which "form letter" they want to use, and the code executes to find the proper record and execute the merge. (The "form letters" are Word documents are already set up as Mail Merge templates, with the OpenDateSource already set up and the fields already linked. This is modeled on WROX Access VBA 2003 example.)

We have been successfully using this with One user for the past 6 weeks. We just added a second user, and find that the .DOTs that are set up and (still) working fine for the first user are giving the error message that the DOT is not a MailMerge document for the second user!!! [The .DOTs are in the same share folder on a server as the .mdb.] We are using A2K.

1) Do I have to set up MailMerge fields for each user at each workstation?
2) Is the "opendatasource" stored on the local machine?

Could someone enlighten me please?

Thanks,

Loralee

If they are .dot's, you may want to create the template association on the local machine. Datasources are defined locally. I think this should work.

mmcdonal

Thanks.. I'll give it a try.

Loralee