 |
 | 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 / January 2004Problem with Word 2003 (not earlier versions)
I have a macro that opens a MailMerge .doc In Word 2003 I receive the message: "Opening this document will run the following SQL command SELECT *. FROM filename Data from your database will be placed in the document. Do you want to continue?" Can I insert code to force YES As a work aroung I have tried changing the document to Not Mailmerge and then coding to MailMerge in the macro. This avoids the above problem but then always asks for the field separator. In this case have tried adding Application.DefaultTableSeparator = "," 'cos they are comma delimited, but this has no effect. Advice gratefully received. John You might find this helpful: http://support.microsoft.com/default.aspx?scid=kb;en- us;827891&Product=wrd2003 Good luck! >-----Original Message----- >I have a macro that opens a MailMerge .doc [quoted text clipped - 21 lines] > >. Useful lead, thanks Matt. Though one bit of advice on that page is unhelpful: Searching for OpenDataSource brings no results Open Data Source does! Have sent them a comment. John >-----Original Message----- >You might find this helpful: [quoted text clipped - 30 lines] >> >. Hi John, See the following article "Opening This Will Run the Following SQL Command" Message When You Open a Word Document - 825765 http://support.microsoft.com?kbid=825765 > I have a macro that opens a MailMerge .doc > [quoted text clipped - 6 lines] > > Can I insert code to force YES Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) Many thanks, Cindy. Now runs without problem John >-----Original Message----- >Hi John, [quoted text clipped - 27 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.