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."