[AccessD] Mail Merge Start Second Copy of Access

That answers that, Charlotte.

Thanks


Rocky

----- Original Message ----- 
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: <accessd at databaseadvisors.com>
Sent: Friday, May 09, 2003 8:15 AM
Subject: RE: [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
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com