 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / March 2004SQL warning message
i have a macro that was written for word 2000 that does a mail merge. we have upgraded to word 2003 and now get a ! message that says "opening this document will run the following SQL command. data from your database will be placed in the document. do you want to continue?" there must be some setting or option to eliminate this message. Thank you! I have been working on a macro for our sales reps to have the ability to create their own mailing labels for their clients. This is the final piece to "Rep Proof" the Mail Merge. Sooooo...I'm in the same boat here. Have been searching all last week for an answer to this question. Thanks in advance for help on this. Austradamis >-----Original Message----- >i have a macro that was written for word 2000 that does a [quoted text clipped - 6 lines] >Thank you! >. You have to add a registry entry. Go to this site http://support.microsoft.com/default.aspx?scid=kb;EN-US;825765 Thanks Rex: Exactly what I was looking for. Using Application.DisplayAlerts=wdAlertsNone will return the default value wich is "No" so modifying the registry was the way to go....couldn't find it though. Also, through my research, they suggest to add a second line after...Application.DisplayAlerts=wdAlertsNone Application.DisplayAlerts=wdAlertsAll...which will turn on and display alerts when the Macro finishes. Thanks again. Austradamis >-----Original Message----- >You have to add a registry entry. Go to this site: > >http://support.microsoft.com/default.aspx?scid=kb;EN-US;825765 >. The same now happens after installing SP3 for Office XP. This must be a security improvement that Microsoft have installed. I can't find any work around. >-----Original Message----- >i have a macro that was written for word 2000 that does a [quoted text clipped - 6 lines] >Thank you! >. From "Rex"'s nearby message: You have to add a registry entry. Go to this site: http://support.microsoft.com/default.aspx?scid=kb;EN-US;825765 I do not know if the same change is applicable to Word 2002 SP3  SignaturePeter Jamieson - Word MVP Word MVP web site http://word.mvps.org/ > The same now happens after installing SP3 for Office XP. > This must be a security improvement that Microsoft have [quoted text clipped - 13 lines] > >Thank you! > >. I have several merge forms which I created in word 2002 using mail merge wizard. After installing updates to my computer yesterday, I'm getting the same message. If I answer YES, my form comes up the same as before I installed updates. If I say NO, then I have to open my data source before working with my document. I use these mail merge forms frequently throughout the course of my workday and don't want to have to click YES or NO every time that I open them. It would be great to be able to eliminate this message! Thanks! >-----Original Message----- >i have a macro that was written for word 2000 that does a [quoted text clipped - 6 lines] >Thank you! >. From "Rex"'s nearby message: You have to add a registry entry. Go to this site: http://support.microsoft.com/default.aspx?scid=kb;EN-US;825765 I do not know if the same change is applicable to Word 2002 SP3 SignaturePeter Jamieson - Word MVP Word MVP web site http://word.mvps.org/ > I have several merge forms which I created in word 2002 > using mail merge wizard. After installing updates to my [quoted text clipped - 18 lines] > >Thank you! > >. The instructions are for Word 2003 and I use Word 2002. One difference in the instructions is that my registry key shows 10.0 instead of 11.0 under software\Microsoft\Office. I continued following the instructions and although the appearance of the Registry Editor is a little different between 2002 & 2003, it was similar enough for me to make good guesses on which steps to take next. I no longer get the SQL warning message when working with my forms. Thank you! >-----Original Message----- >From "Rex"'s nearby message: [quoted text clipped - 29 lines] > >. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.