Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mail Merge using Word XP and Access XP
I just upgraded from Office 2000 Pro to Office XP Pro. I have applied all
the patches for both Windows XP and Office XP. I have several dozen MS Word mailmerge documents using a MS Access DB (on the same computer, but different disk drive letter) as the data source. I've been using these documents for several years and am very comfortable with setup and use with these documents. With Office XP Pro, when I open one of the mailmerge documents, I get the following message "Opening this document will run the following SQL command:" and then the select statement for the document is listed. The error also states that data will be placed in the document and I'm asked if I want to continue. I never got this message in Office 2000 and I don't want it now. How can I get the document to just open and automatically connect to the Access database? Unfortunatly, the problem doesn't stop there. If I click on the Yes button in the above message box, i get a new message box stating that word cannot find it's data source and gives me a dialog to find the data source . After I find the Access database, all of the selection criteria is gone. I redefine the selection criteria and the mailmerge process works correctly. Even though I save the document, the next time I open it, I have to go through the same process again. This same problem occurs when I define a new document, using MS Word XP's wizards. How can I get this annowying process to stop. Thanks, Tom |
#2
|
|||
|
|||
See the following Knowledge Base article:
"Opening This Will Run the Following SQL Command" Message When You Open a Word Document - 825765 at: http://support.microsoft.com?kbid=825765 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Tom Sawyer" wrote in message ... I just upgraded from Office 2000 Pro to Office XP Pro. I have applied all the patches for both Windows XP and Office XP. I have several dozen MS Word mailmerge documents using a MS Access DB (on the same computer, but different disk drive letter) as the data source. I've been using these documents for several years and am very comfortable with setup and use with these documents. With Office XP Pro, when I open one of the mailmerge documents, I get the following message "Opening this document will run the following SQL command:" and then the select statement for the document is listed. The error also states that data will be placed in the document and I'm asked if I want to continue. I never got this message in Office 2000 and I don't want it now. How can I get the document to just open and automatically connect to the Access database? Unfortunatly, the problem doesn't stop there. If I click on the Yes button in the above message box, i get a new message box stating that word cannot find it's data source and gives me a dialog to find the data source . After I find the Access database, all of the selection criteria is gone. I redefine the selection criteria and the mailmerge process works correctly. Even though I save the document, the next time I open it, I have to go through the same process again. This same problem occurs when I define a new document, using MS Word XP's wizards. How can I get this annowying process to stop. Thanks, Tom |
#3
|
|||
|
|||
Doug,
Thank you very much. This solved my problem! Tom "Doug Robbins" wrote: See the following Knowledge Base article: "Opening This Will Run the Following SQL Command" Message When You Open a Word Document - 825765 at: http://support.microsoft.com?kbid=825765 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Tom Sawyer" wrote in message ... I just upgraded from Office 2000 Pro to Office XP Pro. I have applied all the patches for both Windows XP and Office XP. I have several dozen MS Word mailmerge documents using a MS Access DB (on the same computer, but different disk drive letter) as the data source. I've been using these documents for several years and am very comfortable with setup and use with these documents. With Office XP Pro, when I open one of the mailmerge documents, I get the following message "Opening this document will run the following SQL command:" and then the select statement for the document is listed. The error also states that data will be placed in the document and I'm asked if I want to continue. I never got this message in Office 2000 and I don't want it now. How can I get the document to just open and automatically connect to the Access database? Unfortunatly, the problem doesn't stop there. If I click on the Yes button in the above message box, i get a new message box stating that word cannot find it's data source and gives me a dialog to find the data source . After I find the Access database, all of the selection criteria is gone. I redefine the selection criteria and the mailmerge process works correctly. Even though I save the document, the next time I open it, I have to go through the same process again. This same problem occurs when I define a new document, using MS Word XP's wizards. How can I get this annowying process to stop. Thanks, Tom |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automate a mail merge in Word 2002 from a macro in Access 2002 | Mailmerge | |||
mail merge - Access 2000 and Word 2000 | Mailmerge | |||
why word 2000 mail merge opens multiple instances of access table. | Mailmerge | |||
Web-Site-based Word Mail Merge & Access DB | Mailmerge | |||
Word mail merge with Access | Mailmerge |