Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / July 2004

Tip: Looking for answers? Try searching our database.

Mail Merge Issue with Word/Access 2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Andrew Williams - 06 Jul 2004 07:59 GMT
We recently upgraded to Office 2003 and have discovered a
problem with our existing mail merge documents.  We have
several documents that use a query within an Access
database as the data source.  The problem relates to the
use of queries that prompt for parameters.

For example, we have one query that prompts for a from
and to date to retrieve all records between two dates.  
We then have a Word document that uses this as the mail
merge data.  Each time we run the merge it would be for a
different range of dates.  This has worked well in
previous versions of Office because it meant that we had
one document, one database, and one query.

It appears that Office 2003 only allows merges with
Access tables or Access queries without prompts.  Has
anyone had a similar issue?  Any advice would be
appreciated.

Regards,
Andrew Williams
Human Resources
University of Southern Queensland
Toowoomba  Australia
Peter Jamieson - 06 Jul 2004 23:28 GMT
You have to revert to the old DDE connection method to use parameter
queries - check Word Tools|Options|General|"Confirm conversions on
open", go through the connection procedure again, and check the DDE
option when it is offered.

Peter Jamieson

> We recently upgraded to Office 2003 and have discovered a
> problem with our existing mail merge documents.  We have
[quoted text clipped - 20 lines]
> University of Southern Queensland
> Toowoomba  Australia
Andrew Williams - 07 Jul 2004 01:56 GMT
Thanks Peter.  After making this change I now get the
following error when I first load the file;

"The operation cannot be completed because of dialog or
database engin failures.  Please try again later."

However, after re-connecting to the database everthing
works OK.  This method appears to be a bit messy, but at
least it works.

Thanks for your advice.
Andrew
>-----Original Message-----
>You have to revert to the old DDE connection method to use parameter
[quoted text clipped - 29 lines]
>> Toowoomba  Australia
>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.