Saving Query Results for Mailmerge

[Dclegg]

I have a form letter in Word that uses the output from an access query. This is a repetitive operation on a daily basis. The user provides input for the query and the results are written into a RFT format. Word is then called and executes a merge of the data. <br><br>Question, how do you save the results to the same file name without the user having to respond ok to the &quot;Output To&quot; box and respond to the replace the existing file question?<br><br>

 

[DougP]

I would do it slightly different<br>Leave out the RTF part<br>See my FAQ:<br><A HREF="

http://www.tek-tips.com/faq.cfm?spid=181&page=1&CFID=4719042&CFToken=64483187#28"

TARGET="_new">

http://www.tek-tips.com/faq.cfm?spid=181&page=1&CFID=4719042&CFToken=64483187#28</A>

<p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[Dclegg]

Thanks for the info.&nbsp;&nbsp;I'm actually trying to this behind the scenes for the user rather than a command button.&nbsp;&nbsp;Will play with your code from the FAQ to see what I can do.