Trouble with some mail merges between MS Access & Word

[ellie]

Our group has transitioned from Office 2003 to 2007. We have a large db
shared by about 7-8 users. We're currently have some issues with mail
merges. They are based on queries in MS Access that have date parameters.
Some work, some don't. I've attempted creating a new merge, both starting
from Access, as well as starting from Word. It's saying either that Word
can't open the data source, or that the header has no info. Any help?
Thanks!

 

[Jeff Boyce]

Do you have an example of the SQL statement for one of those that isn't
working? For one that is working?

Is this "every time", or is this "sometimes"?

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[De Jager]

Our group has transitioned from Office 2003 to 2007. We have a large db
shared by about 7-8 users. We're currently have some issues with mail
merges. They are based on queries in MS Access that have date parameters.
Some work, some don't. I've attempted creating a new merge, both starting
from Access, as well as starting from Word. It's saying either that Word
can't open the data source, or that the header has no info. Any help?
Thanks!