[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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030509/632d0edd/attachment-0001.html>