I need to create a similar function to automate the Access query results into a premade Word mailmerge document. I also need to set a command button on the form so the user need only click the one button to perform the above task(s). <p>I am unsure of the syntax for procedure and wonder if the sample you provided will work. <p><p>Dave

This is a discussion about <B>The Way We Word: Merge That Mail Automatically!</b>.<p align='center'><a href=http://www.mcpressonline.com/mc? This e-mail address is being protected from spam bots, you need JavaScript enabled to view it @.6ae389e3>Click here for the article</a>.</p>

I am trying to create a mail merge from code where the query for the field list comes from a stored procedure. Do you have how to make word use the stored procedure? <p>Example code looks like <p> WordDoc.MailMerge.OpenDataSource(Name:="", _ <BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Connection:="DSN=$RMPLATINUM$", _ <BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SQLStatement:="exec MailMergeFieldList", LinkToSource:=False, AddToRecentFiles:=False) <p>Thanks