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!
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.