Problem after upgrading to Word2002

D

Daveinomaha

When I was using Office 2000, I had a query defined in
Access 2000 that requested a date range that I used as an
input file to a Mail Merge document in Word 2000. I would
enter the beginning and ending date and the records that
fit that range would print. I have updated to Office XP
Professional and now it will not work. I have to manually
change the date in the query each time now and then run
the mail merge document.

What do I have to do to fix this problem?
I want to enter the 2 dates in pop up boxes as before and
then run the mail merge document without having to run
the mail merge wizard each time?

Thanks in advance for your help.

Dave in Omaha
 
P

Peter Jamieson

The only way you can run parameter queries in Word 2002 mailmerge is to
revert to the old DDE connection method - check
Word|Tools|Options|General|"Confirm conversions at open", go through the
connection process again, and select the Access via DDE option when
prompted.
 

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

Top