Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / May 2008

Tip: Looking for answers? Try searching our database.

Macro works fine... but...?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kenneth - 22 May 2008 02:11 GMT
Howdy,

I'm using Word 2002 and know next to nothing about VBA, but
have had much success with the "R&T" approach (that is,
Record, and Tweak.)

I just did that with a bunch of macros to do simple mail
merge functions, and they work fine, with one modest
difficulty:

When I run the macros, a dialog appears that says:

"Opening this document will run the following SQL command

SELECT*FROM Z:\MailMerge\LET.TXT

When I clear the dialog by manually clicking OK, the merge
continues properly, and all is well.

What command can I put in the code to eliminate that manual
intervention?

That is, what command will tell Word to use the designated
data file for the merge?

(I will add that I tried to use the VBA help file, but can't
get it to work properly. When I try to enter anything in the
search field, instead of seeing the field entry mouse
cursor, I see the "<-->" cursor of the sort used to widen a
form. No matter what I do, I can't change that cursor shape,
and so, can't find a way to access the search function of
help. I would certainly welcome any insight into that
wrinkle...)

Sincere thanks,
Signature

Kenneth

If you email... Please remove the "SPAMLESS."

Doug Robbins - Word MVP - 22 May 2008 13:12 GMT
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

Signature

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

> Howdy,
>
[quoted text clipped - 31 lines]
>
> Sincere thanks,
Kenneth - 22 May 2008 15:20 GMT
>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

Hi Doug,

That did the deed...

Many thanks,
Signature

Kenneth

If you email... Please remove the "SPAMLESS."

 
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.