By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,173 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

Problems with Automation (Access to Word) in Office 2003

P: n/a
Hello,

Since I installed Office 2003, I'm experiencing problems with an
automation procedure in Access (created in Access 2000) that colonizes
fields in a Word merge file. I keep getting a warning saying that it is
not a merge file, even thought it has been predefined as such with all
the fields. I relinked it to a query, but when I run the code, it won't
reconize the file as a merge file. I redid the merge file using Office
2003 and it still won't hold a connection to the source. Has anyone had
this problem?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Yes automation has been fine until Word 2003! No solution!?
M. C <co*****@mcmaster.ca> wrote in message news:<40*********************@news.frii.net>...
Hello,

Since I installed Office 2003, I'm experiencing problems with an
automation procedure in Access (created in Access 2000) that colonizes
fields in a Word merge file. I keep getting a warning saying that it is
not a merge file, even thought it has been predefined as such with all
the fields. I relinked it to a query, but when I run the code, it won't
reconize the file as a merge file. I redid the merge file using Office
2003 and it still won't hold a connection to the source. Has anyone had
this problem?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 12 '05 #2

P: n/a
Jem
There is one element you didn't mention having recompiled the
automation procedure itself. In my experience they are very touchy,
even the seemingly simple ones, so if you haven't done so, rewrite it
step by step. If you had either or both (old) applications running
when it was originally written, do the same thing again (with the new
versions of course). It may sound like voodoo, but quite possibly
there are system calls going on that you're unaware of which also need
to be updated in a particular sequence (eg registry settings).

If that doesn't work, try Cindy Meister. I found her articles on mail
merge invaluable when automating a 3,000 record merge into Word, and
the 400 page book that resulted printed out like a dream without a
single error. She's the best.

Don't give up!
Jem
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.