SQL Warning opening Word 2003

[NevilleT]

I have put this on several newsgroups but no answer as
yet. When I open Word 2003, I get a warning message

Opening this file will run the following SQL command
Select * from MrgFile.txt
Data from your database will be placed in the document. Do
you want to continue?

Sounds like a mail merge so I thought I would try here.
Found a knowledge base article 827565 which talks about
macros and registry settings but not keen to go there as I
have not worked out how to create a macro.

Any ideas

 

[Peter Jamieson]

Found a knowledge base article 827565 which talks about

macros and registry settings but not keen to go there as I
have not worked out how to create a macro.

(For the benefit of other readers, as far as I can see the article number is
825765).

You don't need a macro to change this setting (In fact I can't see where it
mentions one in the article so I hope we are seeing the same thing).

I think if you follow the steps described, starting with "Open Registry
Editor", you should be OK.

Typically, the registry editor is called regedit.exe and is in your Windows
directory (c:\Windows, c:\winnt or whatever)

 

[NevilleT]

Hi Peter and thanks for your help. I did transpose
numbers in the article. It was 825765. The reference to
macro is in the second paragraph under "More Information"

"You can use a VBA macro with the command to suppress this
message:
application.DisplayAlerts= wdAlertsNone"

I will try changes to the registry and see how that works.

Regards

Neville

 

[Peter Jamieson]

"You can use a VBA macro with the command to suppress this

message:
application.DisplayAlerts= wdAlertsNone"

Yes, sorry, of course it does. A pain.

As for macro creation, I'd look at
http://www.mvps.org/word/FAQs/MacrosVBA/CreateAMacro.htm
and in this case,
http://www.mvps.org/word/FAQs/MacrosVBA/ApplicationEvents.htm
as you may need an AutoExec macro in Word