Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
SQL Prompt When opening merged documents
Hello. I've read KB 825765 so I understand when and why I get prompted with
the "Opening this will run the following SQL command" message when you open a Word mail merge main document that is linked to a data source. However, I do not understand why I get prompted for the document after the merge has run and my new document has been created and saved. When I close and reopen the newly created document, I still get the prompt. There is obviously a data attachment still existing. Is there any way to break that attachment? I may not be understanding clearly how the merge process worked. I thought it brought data into the new document and that's it. Is it continuously going to the data source to get the data? Any help/advice would be appreciated. Thanks, Jennifer Dickens |
#2
|
|||
|
|||
Are you sure that you have actually executed the merge to a new document?
I suggest that you select Toolbars from the View menu and then check the mailmerge item to display the mailmerge toolbar, then use the buttons on the Right Hand end of the toolbar to execute the mailmerge. -- 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 "Jeni Q" wrote in message ... Hello. I've read KB 825765 so I understand when and why I get prompted with the "Opening this will run the following SQL command" message when you open a Word mail merge main document that is linked to a data source. However, I do not understand why I get prompted for the document after the merge has run and my new document has been created and saved. When I close and reopen the newly created document, I still get the prompt. There is obviously a data attachment still existing. Is there any way to break that attachment? I may not be understanding clearly how the merge process worked. I thought it brought data into the new document and that's it. Is it continuously going to the data source to get the data? Any help/advice would be appreciated. Thanks, Jennifer Dickens |
#3
|
|||
|
|||
Yes, I'm pretty sure that the merge has been executed. Typically, when you
have not executed the merge, most of the toolbar buttons are available to you. You can also see the field shading (I have mine set to Always). In this completed document, there are no shaded fields appearing and the only mailmerge toolbar buttons available are Main Document Setup and Open Data Source. So it clearly seems to me that it has merged. However, it's insistence on prompting to connect to the data source on open proves otherwise. What could be keeping the connection? Jennifer "Doug Robbins" wrote in message ... : Are you sure that you have actually executed the merge to a new document? : : I suggest that you select Toolbars from the View menu and then check the : mailmerge item to display the mailmerge toolbar, then use the buttons on the : Right Hand end of the toolbar to execute the mailmerge. : : -- : 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 : "Jeni Q" wrote in message : ... : Hello. I've read KB 825765 so I understand when and why I get prompted : with : the "Opening this will run the following SQL command" message when you : open : a Word mail merge main document that is linked to a data source. : : However, I do not understand why I get prompted for the document after the : merge has run and my new document has been created and saved. When I close : and reopen the newly created document, I still get the prompt. There is : obviously a data attachment still existing. Is there any way to break that : attachment? : : I may not be understanding clearly how the merge process worked. I thought : it brought data into the new document and that's it. Is it continuously : going to the data source to get the data? : : Any help/advice would be appreciated. : : Thanks, : Jennifer Dickens : : : : |
#4
|
|||
|
|||
If you toggle on the field codes in the document (Alt+F9) what do you see?
Any mergefields? -- 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 "Jeni Q" wrote in message ... Yes, I'm pretty sure that the merge has been executed. Typically, when you have not executed the merge, most of the toolbar buttons are available to you. You can also see the field shading (I have mine set to Always). In this completed document, there are no shaded fields appearing and the only mailmerge toolbar buttons available are Main Document Setup and Open Data Source. So it clearly seems to me that it has merged. However, it's insistence on prompting to connect to the data source on open proves otherwise. What could be keeping the connection? Jennifer "Doug Robbins" wrote in message ... : Are you sure that you have actually executed the merge to a new document? : : I suggest that you select Toolbars from the View menu and then check the : mailmerge item to display the mailmerge toolbar, then use the buttons on the : Right Hand end of the toolbar to execute the mailmerge. : : -- : 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 : "Jeni Q" wrote in message : ... : Hello. I've read KB 825765 so I understand when and why I get prompted : with : the "Opening this will run the following SQL command" message when you : open : a Word mail merge main document that is linked to a data source. : : However, I do not understand why I get prompted for the document after the : merge has run and my new document has been created and saved. When I close : and reopen the newly created document, I still get the prompt. There is : obviously a data attachment still existing. Is there any way to break that : attachment? : : I may not be understanding clearly how the merge process worked. I thought : it brought data into the new document and that's it. Is it continuously : going to the data source to get the data? : : Any help/advice would be appreciated. : : Thanks, : Jennifer Dickens : : : : |
#5
|
|||
|
|||
Is your document based on (associated with) a template (.dot) that is
connected to a data source? If so, you might recieve this message in recent versions of Word because when the template opens, it tries to connect to the data source. Peter Jamieson "Jeni Q" wrote in message ... Yes, I'm pretty sure that the merge has been executed. Typically, when you have not executed the merge, most of the toolbar buttons are available to you. You can also see the field shading (I have mine set to Always). In this completed document, there are no shaded fields appearing and the only mailmerge toolbar buttons available are Main Document Setup and Open Data Source. So it clearly seems to me that it has merged. However, it's insistence on prompting to connect to the data source on open proves otherwise. What could be keeping the connection? Jennifer "Doug Robbins" wrote in message ... : Are you sure that you have actually executed the merge to a new document? : : I suggest that you select Toolbars from the View menu and then check the : mailmerge item to display the mailmerge toolbar, then use the buttons on the : Right Hand end of the toolbar to execute the mailmerge. : : -- : 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 : "Jeni Q" wrote in message : ... : Hello. I've read KB 825765 so I understand when and why I get prompted : with : the "Opening this will run the following SQL command" message when you : open : a Word mail merge main document that is linked to a data source. : : However, I do not understand why I get prompted for the document after the : merge has run and my new document has been created and saved. When I close : and reopen the newly created document, I still get the prompt. There is : obviously a data attachment still existing. Is there any way to break that : attachment? : : I may not be understanding clearly how the merge process worked. I thought : it brought data into the new document and that's it. Is it continuously : going to the data source to get the data? : : Any help/advice would be appreciated. : : Thanks, : Jennifer Dickens : : : : |
#6
|
|||
|
|||
I think this must be what's happening. The weird thing is that one time I
got it to work right. But I can't remember how. :-O "Peter Jamieson" wrote in message ... : Is your document based on (associated with) a template (.dot) that is : connected to a data source? If so, you might recieve this message in recent : versions of Word because when the template opens, it tries to connect to the : data source. : : Peter Jamieson : : "Jeni Q" wrote in message : ... : Yes, I'm pretty sure that the merge has been executed. Typically, when you : have not executed the merge, most of the toolbar buttons are available to : you. You can also see the field shading (I have mine set to Always). In : this : completed document, there are no shaded fields appearing and the only : mailmerge toolbar buttons available are Main Document Setup and Open Data : Source. So it clearly seems to me that it has merged. : : However, it's insistence on prompting to connect to the data source on : open : proves otherwise. What could be keeping the connection? : : Jennifer : : "Doug Robbins" wrote in message : ... : : Are you sure that you have actually executed the merge to a new : document? : : : : I suggest that you select Toolbars from the View menu and then check the : : mailmerge item to display the mailmerge toolbar, then use the buttons on : the : : Right Hand end of the toolbar to execute the mailmerge. : : : : -- : : 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 : : "Jeni Q" wrote in message : : ... : : Hello. I've read KB 825765 so I understand when and why I get prompted : : with : : the "Opening this will run the following SQL command" message when you : : open : : a Word mail merge main document that is linked to a data source. : : : : However, I do not understand why I get prompted for the document after : the : : merge has run and my new document has been created and saved. When I : close : : and reopen the newly created document, I still get the prompt. There : is : : obviously a data attachment still existing. Is there any way to break : that : : attachment? : : : : I may not be understanding clearly how the merge process worked. I : thought : : it brought data into the new document and that's it. Is it : continuously : : going to the data source to get the data? : : : : Any help/advice would be appreciated. : : : : Thanks, : : Jennifer Dickens : : : : : : : : : : : : |
#7
|
|||
|
|||
Don't know if that is what has happened, but if it is and you do not need
your mail merge main document to be connected to this template, disconnect it, or alternatively, disconnect the template and set up the connection in a VBA AutoNew macro if you know how to do that. In many cases, the sensible thing to do when dealing with mailmerge is to develop your mail merge main document, connect it to its data source, associate it with the normal.dot template, then save it, and avoid using a special template - it's not how Word is really supposed to work, but it probably causes fewer problems with mailmerge, unless, for example, you need to use fields such as ASK, FILLIN, and (especially) CREATEDATE, which tend to work differently when you create a new document from a template. recieve can't believe I used that spelling, even by accident! Peter Jamieson "Jeni Q" wrote in message ... I think this must be what's happening. The weird thing is that one time I got it to work right. But I can't remember how. :-O "Peter Jamieson" wrote in message ... : Is your document based on (associated with) a template (.dot) that is : connected to a data source? If so, you might recieve this message in recent : versions of Word because when the template opens, it tries to connect to the : data source. : : Peter Jamieson : : "Jeni Q" wrote in message : ... : Yes, I'm pretty sure that the merge has been executed. Typically, when you : have not executed the merge, most of the toolbar buttons are available to : you. You can also see the field shading (I have mine set to Always). In : this : completed document, there are no shaded fields appearing and the only : mailmerge toolbar buttons available are Main Document Setup and Open Data : Source. So it clearly seems to me that it has merged. : : However, it's insistence on prompting to connect to the data source on : open : proves otherwise. What could be keeping the connection? : : Jennifer : : "Doug Robbins" wrote in message : ... : : Are you sure that you have actually executed the merge to a new : document? : : : : I suggest that you select Toolbars from the View menu and then check the : : mailmerge item to display the mailmerge toolbar, then use the buttons on : the : : Right Hand end of the toolbar to execute the mailmerge. : : : : -- : : 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 : : "Jeni Q" wrote in message : : ... : : Hello. I've read KB 825765 so I understand when and why I get prompted : : with : : the "Opening this will run the following SQL command" message when you : : open : : a Word mail merge main document that is linked to a data source. : : : : However, I do not understand why I get prompted for the document after : the : : merge has run and my new document has been created and saved. When I : close : : and reopen the newly created document, I still get the prompt. There : is : : obviously a data attachment still existing. Is there any way to break : that : : attachment? : : : : I may not be understanding clearly how the merge process worked. I : thought : : it brought data into the new document and that's it. Is it : continuously : : going to the data source to get the data? : : : : Any help/advice would be appreciated. : : : : Thanks, : : Jennifer Dickens : : : : : : : : : : : : |
#8
|
|||
|
|||
In the MS Help, it says the following:
Restore a mail merge main document to a regular document By removing the associated data source from a main document, you can convert it to a regular document. 1.. Open the main document from which you want to remove the data source. 2.. On the View menu, point to Toolbars, and then click Mail Merge. 3.. Click Main Document Setup . 4.. Click Normal Word document. OK, so I tried this on one of these completed documents and the radio button is already set to Normal Word Document. It may be helpful to explain what I'm doing. I have a letter that has form fields in it. These fields relate back to an excel spreadsheet. When the user wants to create a new letter, he updates the fields in the spreadsheet. He is typically creating one letter at a time, not many. The fields are manually entered into the spreadsheet in one location, and they are copied from that location to a temporary place in the spreadsheet. That way he can keep a record of the letters he's sent, but has a separate page in which he can paste one row of data for a single merge. The Word template is associated to the data, and the location of the data always remains the same. It must be something about the template, the way it stores the connection to the data fields... "Jeni Q" wrote in message ... : Hello. I've read KB 825765 so I understand when and why I get prompted with : the "Opening this will run the following SQL command" message when you open : a Word mail merge main document that is linked to a data source. : : However, I do not understand why I get prompted for the document after the : merge has run and my new document has been created and saved. When I close : and reopen the newly created document, I still get the prompt. There is : obviously a data attachment still existing. Is there any way to break that : attachment? : : I may not be understanding clearly how the merge process worked. I thought : it brought data into the new document and that's it. Is it continuously : going to the data source to get the data? : : Any help/advice would be appreciated. : : Thanks, : Jennifer Dickens : : |
#9
|
|||
|
|||
There are better ways of doing what the user wants. One is contained in the
last of the following series of articles: Please Fill Out This Form Part 1: Create professional looking forms in Word http://www.computorcompanion.com/LPMArticle.asp?ID=22 Part 2: Adding Automation to your Word forms. http://www.computorcompanion.com/LPMArticle.asp?ID=46 Part 3: Learn more VBA (macros) to automate your forms. http://www.computorcompanion.com/LPMArticle.asp?ID=119 Part 4: Use custom dialog boxes in your Word forms http://www.computorcompanion.com/LPMArticle.asp?ID=127 Part 5: Connect your AutoForm to a database to save input time and keep better records! http://www.computorcompanion.com/LPMArticle.asp?ID=136 -- 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 "Jeni Q" wrote in message ... In the MS Help, it says the following: Restore a mail merge main document to a regular document By removing the associated data source from a main document, you can convert it to a regular document. 1.. Open the main document from which you want to remove the data source. 2.. On the View menu, point to Toolbars, and then click Mail Merge. 3.. Click Main Document Setup . 4.. Click Normal Word document. OK, so I tried this on one of these completed documents and the radio button is already set to Normal Word Document. It may be helpful to explain what I'm doing. I have a letter that has form fields in it. These fields relate back to an excel spreadsheet. When the user wants to create a new letter, he updates the fields in the spreadsheet. He is typically creating one letter at a time, not many. The fields are manually entered into the spreadsheet in one location, and they are copied from that location to a temporary place in the spreadsheet. That way he can keep a record of the letters he's sent, but has a separate page in which he can paste one row of data for a single merge. The Word template is associated to the data, and the location of the data always remains the same. It must be something about the template, the way it stores the connection to the data fields... "Jeni Q" wrote in message ... : Hello. I've read KB 825765 so I understand when and why I get prompted with : the "Opening this will run the following SQL command" message when you open : a Word mail merge main document that is linked to a data source. : : However, I do not understand why I get prompted for the document after the : merge has run and my new document has been created and saved. When I close : and reopen the newly created document, I still get the prompt. There is : obviously a data attachment still existing. Is there any way to break that : attachment? : : I may not be understanding clearly how the merge process worked. I thought : it brought data into the new document and that's it. Is it continuously : going to the data source to get the data? : : Any help/advice would be appreciated. : : Thanks, : Jennifer Dickens : : |
#10
|
|||
|
|||
We're using Excel, not Access. Will this work the same? Do I use this
library for the connection: Microsoft ActiveX Data Object 2.5 Library? Also, I do not want to automatically input data from my form into the database. I only want the data to come from the spreadsheet into the letter. Does the example to which you pointed me allow me to have this sort of one-way connection? Thanks, Jennifer "Doug Robbins" wrote in message ... : There are better ways of doing what the user wants. One is contained in the : last of the following series of articles: : : Please Fill Out This Form : Part 1: Create professional looking forms in Word : http://www.computorcompanion.com/LPMArticle.asp?ID=22 : : Part 2: Adding Automation to your Word forms. : http://www.computorcompanion.com/LPMArticle.asp?ID=46 : : Part 3: Learn more VBA (macros) to automate your forms. : http://www.computorcompanion.com/LPMArticle.asp?ID=119 : : Part 4: Use custom dialog boxes in your Word forms : http://www.computorcompanion.com/LPMArticle.asp?ID=127 : : Part 5: Connect your AutoForm to a database to save input time and keep : better records! : http://www.computorcompanion.com/LPMArticle.asp?ID=136 : : : -- : 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 : "Jeni Q" wrote in message : ... : In the MS Help, it says the following: : Restore a mail merge main document to a regular document : By removing the associated data source from a main document, you can : convert it to a regular document. : : 1.. Open the main document from which you want to remove the data : source. : 2.. On the View menu, point to Toolbars, and then click Mail Merge. : 3.. Click Main Document Setup . : 4.. Click Normal Word document. : : : OK, so I tried this on one of these completed documents and the radio : button : is already set to Normal Word Document. : : It may be helpful to explain what I'm doing. I have a letter that has form : fields in it. These fields relate back to an excel spreadsheet. When the : user wants to create a new letter, he updates the fields in the : spreadsheet. : He is typically creating one letter at a time, not many. The fields are : manually entered into the spreadsheet in one location, and they are copied : from that location to a temporary place in the spreadsheet. That way he : can : keep a record of the letters he's sent, but has a separate page in which : he : can paste one row of data for a single merge. The Word template is : associated to the data, and the location of the data always remains the : same. : : It must be something about the template, the way it stores the connection : to : the data fields... : : : "Jeni Q" wrote in message : ... : : Hello. I've read KB 825765 so I understand when and why I get prompted : with : : the "Opening this will run the following SQL command" message when you : open : : a Word mail merge main document that is linked to a data source. : : : : However, I do not understand why I get prompted for the document after : the : : merge has run and my new document has been created and saved. When I : close : : and reopen the newly created document, I still get the prompt. There is : : obviously a data attachment still existing. Is there any way to break : that : : attachment? : : : : I may not be understanding clearly how the merge process worked. I : thought : : it brought data into the new document and that's it. Is it continuously : : going to the data source to get the data? : : : : Any help/advice would be appreciated. : : : : Thanks, : : Jennifer Dickens : : : : : : : : : |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Upon opening, can Word pull up same 4 documents automatically? | Microsoft Word Help | |||
Certain "word" documents opening in larger font and appearing bigg | Microsoft Word Help | |||
best way to handle five documents that need to be merged in the e. | Microsoft Word Help | |||
Opening templates as documents | Microsoft Word Help | |||
Sending Merged Documents to Printer Individually | Mailmerge |