Connecting to an Access Query

P

Paul Warshawsky

I have a fairly complicated database that includes a Query which, based on two values input by the user (in the Criteria parameter [Enter value 1]), combines the various tables to give me the fields that I want to see. I would like to use the results of this query for a MailMerge in Word, but I don't want to have to run the Query each time - I want Word to connect to the Query, allow me to enter the parameters and use that data for the mailmerge

Any suggestions

Paul
 
C

Cindy M -WordMVP-

Hi =?Utf-8?B?UGF1bCBXYXJzaGF3c2t5?=,
I have a fairly complicated database that includes a Query which, based on two values input by the user (in the Criteria parameter [Enter value 1]), combines the various tables to give me the fields that I want to see. I would like to use the results of this query for a MailMerge in Word, but I don't want to have to run the Query each time - I want Word to connect to the Query, allow me to enter the parameters and use that data for the mailmerge.
Click to expand...
It would certainly help a lot to know which version of Word you're working with?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Modern equivalent of Autotext in Word? 0
Word macro that can call cells out of Excel for a find and replace 0
MailMerge Query 1
How to make repeating drop-down lists? 2
How to Change criteria on a saved query using VBA 0
Access to Word 2003 Mailmerge 1
add mergefields to exsting word 2013 2

Top