11-27-06, 10:57 #1Registered User
- Join Date
- Nov 2004
Unanswered: Access 2000 Mail Merge Word 2003 via asp from Intranet
Problem: Launching Word 2003 from our Intranet and executing a mail merge based on an Access 2000 query.
This worked fine under Word 2000/Access 2000 but now fails either with the “Word could not re-establish a DDE connection…” statement or the document launches with no merge at all!
Staff select records from an Access 2000 database via Intranet. The selection is held against their staff no in a joined table (the 2nd table only holding the Database ID and one other field).
Staff then launch one of 3 Word templates by clicking on a button. Word launches in a separate window and the Merge should then launch with the request to enter their staff number to enable the merge to select only those records pertaining to them.
I have tried all the Microsoft work arounds and none work!
11-27-06, 13:33 #2(Making Your Life Easy)
Provided Answers: 10
- Join Date
- Feb 2004
- New Zealand
have you look into microsoft sharepointhope this help
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
VB-NET based on my own environment started 2007
SQL-2005 based on my own environment started 2008
YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
THEY'RE BEHIND YOU FOR A REASON