<!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.1226" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=275410514-23092003><FONT face=Arial color=#0000ff size=2>That's
kind of what I thought. Thanks!</FONT></SPAN></DIV>
<DIV> </DIV>
<P><FONT size=2>John W. Colby<BR>www.colbyconsulting.com</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of
</B>paul.hartland@fsmail.net<BR><B>Sent:</B> Tuesday, September 23, 2003 9:43
AM<BR><B>To:</B> Access Developers discussion and problem
solving<BR><B>Subject:</B> Re: [AccessD] Mail Merge<BR><BR></FONT></DIV>
<P>John,</P>
<P>The quick and dirty way to to this is to set the queries up in Access that
you require for your mailmerge docs. Then link the docs to the queries
using the mailmerge wizard, and put the fields from the query in the required
locations. </P>
<P>Then if you need to open the docs give the user a choice of which one they
want and use objects to open the required word doc. As it is already
linked to the query you require, al they should have to do is click the merge
button<BR></P>
<P>Paul </P>
<P>P.S. sorry it isn't explained to well, only I'm under a tight deadline at
the moment.....if you need further info let me know......<BR><BR><BR></P>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #ff0000 2px solid">Message
date : Sep 23 2003, 02:33 PM <BR>From : John Colby
<JCOLBY@COLBYCONSULTING.COM><BR>To : AccessD
<ACCESSD@DATABASEADVISORS.COM><BR>Copy to : <BR>Subject : [AccessD] Mail
Merge <BR>Folks, <BR><BR>I have been looking at a push method of mail merge
were an access class <BR>pushes data into the doc at bookmarks. It is my
understanding that there is <BR>also a pull method where the document knows
what query it needs to use to <BR>get data from Access and where to put the
data in the document. Is that <BR>method easy to set up for a given
document? Any online references for doing <BR>this? I need to get a handful
of mail merge docs set up quickly for a <BR>customer. <BR><BR>John W. Colby
<BR>www.colbyconsulting.com
<BR><BR><BR>_______________________________________________ <BR>AccessD
mailing list <BR>AccessD@databaseadvisors.com
<BR>http://databaseadvisors.com/mailman/listinfo/accessd <BR>Website:
http://www.databaseadvisors.com <BR></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>