prompting to enter date in an email merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nicole - 06 May 2004 01:34 GMT

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?

Reply to this Message

Cindy M -WordMVP- - 06 May 2004 14:48 GMT

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:
[quoted text clipped - 5 lines]
> 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 :-)

Reply to this Message

Peter Jamieson - 06 May 2004 15:55 GMT

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.

Signature

Peter Jamieson

> I'm using Access for my database. I have created a query and in the date
> field for the criteria I have:
[quoted text clipped - 8 lines]
> Does anyone know how to create an email merge where it will allow the
> capability of prompting for the dates in Word?

Reply to this Message