|
|
|
date: Wed, 21 May 2008 21:11:27 -0400,
group: microsoft.public.word.vba.beginners
back
Macro works fine... but...?
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,
--
Kenneth
If you email... Please remove the "SPAMLESS."
date: Wed, 21 May 2008 21:11:27 -0400
author: Kenneth
Re: Macro works fine... but...?
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
--
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
"Kenneth" wrote in message
news:b0i9341rsktu029l67u128v6nvl1u4dbta@4ax.com...
>
>
> 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,
> --
> Kenneth
>
> If you email... Please remove the "SPAMLESS."
date: Thu, 22 May 2008 22:12:30 +1000
author: Doug Robbins - Word MVP
|
|
