Mail merge in Access

[Tapiwa JONGWE]

I have an Access program that uses Word's Mail merge to print different type
of letters depending on the data sourcewhich is an Acces Table.

When one clicks the button to activate the mail merge, Access opens one or
even two ther instcances of Access. Each instance asks for a user name and
password before it goes on to merge the data and print the letters.

How can I avoid the other intsnaces appearing.

In my code, the button to print the letters calls the sub fMailMerge() as
below.

Call fMailMerge("Contrat.doc")

The sub fMailMerge() is as below

Sub fMailMerge(fileName)
Dim objWord As Word.Document
Dim stMergeDoc As String

stMergeDoc = "\\server_per\public\per\training\internship\letters\"
stMergeDoc = stMergeDoc & fileName

Since "fileName" has an access table as it'smdata source, I have the
impression that the program starts Access again in order to open the
approriate table. Why can't the current instance open the table (mail merge)
without opening another instance of Access.

Any help will be greatly apprecitaed.

 

[Van T. Dinh]

See if the following Microsoft Knowledge Base article helps:

http://support.microsoft.com/?id=199963

 

[Tapiwa JONGWE]

Thanks a lot. However the solution in the article does not for Access 2000.
Any other ideas?

 

[Van T. Dinh]

Sorry, no ideas. I tend use Automation filling in the Word DocVariables
mostly rather than MailMerge.

Suggest searching the Microsoft Knowledge Base for a similar article to the
one I posted.