[AccessD] Mail Merge Start Second Copy of Access

Mail merges look for a window title that starts with  "Microsoft Access"
to determine if an instance is running.  If you have set the apptitle to
something else, it will launch another instance.

Charlotte Foust

-----Original Message-----
From: John Bartow [mailto:john at winhaven.net] 
Sent: Friday, May 09, 2003 6:08 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Mail Merge Start Second Copy of Access


Rocky,
IIRC there is something quirky about mail merges that opens a second
copy of access if your Access app has an application title or icon set
in the startup properties.

One among the many reasons that I eventually went away from mail merging
with access directly. I now dump the data to an text file and merged
word with it (thanks again Brett). I could send you the code for those
procedures if you want. Most of it came from this list.

JB

 -----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin -
Beach Access Software
Sent: Thursday, May 08, 2003 7:14 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Mail Merge Start Second Copy of Access


Dear List:

I do a mail merge from an A2K app to Word.  The user selects the
document to merge to.  They set the doc up before hand using as a data
source a table in the app front end.  I put the customer name and
address info in this table and it merges quite nicely into the word doc.

But the merging opens up Access and the front end a second time.
Doesn't really bother the user too much but they'd like to get rid of it
if possible.  User insists it didn't used to do that and now it does.  I
can't remember.  They're running Win2K and A2K.

I speculated that it opened up the second instance because of the link
to the front end table as the data source for the merge.

anyway, is this normal?  Can it stopped?

MTIA,

Rocky Smolin
Beach Access Software