<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=500505213-09052003><FONT face=Arial color=#0000ff
size=2>Rocky,</FONT></SPAN></DIV>
<DIV><SPAN class=500505213-09052003><FONT face=Arial color=#0000ff
size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=500505213-09052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=500505213-09052003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=500505213-09052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=500505213-09052003><FONT face=Arial color=#0000ff
size=2>JB</FONT></SPAN></DIV>
<DIV><SPAN class=500505213-09052003></SPAN><FONT face=Tahoma><FONT size=2><SPAN
class=500505213-09052003><FONT face=Arial
color=#0000ff> </FONT></SPAN></FONT></FONT></DIV>
<DIV><FONT face=Tahoma><FONT size=2><SPAN
class=500505213-09052003> </SPAN>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Rocky Smolin -
Beach Access Software<BR><B>Sent:</B> Thursday, May 08, 2003 7:14
PM<BR><B>To:</B> AccessD@databaseadvisors.com<BR><B>Subject:</B> [AccessD] Mail
Merge Start Second Copy of Access<BR><BR></DIV></FONT></FONT>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial size=2>Dear List:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>anyway, is this normal? Can it
stopped?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>MTIA,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky Smolin<BR>Beach Access
Software</FONT></DIV>
<DIV> </DIV></BLOCKQUOTE></BODY></HTML>