prompting to enter date in an email merge

[Nicole]

I'm using Access for my database. I have created a query and in the date
field for the criteria I have:

Between [Enter the beginning date] And [Enter the ending date]

When I'm in word and trying to create an email merge, I can't select this
query with the criteria above. It won't show this query as an option. If I
change the query to actual dates instead of prompting for dates, then it
will work.

Does anyone know how to create an email merge where it will allow the
capability of prompting for the dates in Word?

 

[Cindy M -WordMVP-]

Hi Nicole,

You don't mention the version of Office you're using, which makes it difficult
to give you a firm-and-fast answer. I'm guessing you have Word 2002 or 2003.
These versions can't use parameter queries by default, due to the default
connection method. You need to use DDE, explicitly, to use an Access parameter
query as the data source.

You'll find information on how to select the connection method in the Word
2002 section of my website's mail merge FAQ.

I'm using Access for my database. I have created a query and in the date
field for the criteria I have:

Between [Enter the beginning date] And [Enter the ending date]

When I'm in word and trying to create an email merge, I can't select this
query with the criteria above. It won't show this query as an option. If I
change the query to actual dates instead of prompting for dates, then it
will work.

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

 

[Peter Jamieson]

Assuming you are using Word 2002 or 2003, you need to revert to the old DDE
method of connecting to the Access database - check
Word|Tools|Options|"Confirm conversion at open", go through the connection
process again, and select the DDE option when prompted. Word will then start
Access and Access asks for the parameter values - be careful because the
prompts can sometimes be hidden behind other program windows which can make
it seem as if nothing is happening.