SQL Warning opening Word 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NevilleT - 07 Nov 2003 02:41 GMT

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

Reply to this Message

Peter Jamieson - 07 Nov 2003 11:32 GMT

> 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)

--
Peter Jamieson
MS Word MVP

> I have put this on several newsgroups but no answer as
> yet. When I open Word 2003, I get a warning message
[quoted text clipped - 10 lines]
>
> Any ideas

Reply to this Message

NevilleT - 13 Nov 2003 00:05 GMT

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

>-----Original Message-----
>> Found a knowledge base article 827565 which talks about
[quoted text clipped - 33 lines]
>
>.

Reply to this Message

Peter Jamieson - 13 Nov 2003 09:02 GMT

> "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
--
Peter Jamieson
MS Word MVP

> Hi Peter and thanks for your help. I did transpose
> numbers in the article. It was 825765. The reference to
[quoted text clipped - 57 lines]
> >
> >.

Reply to this Message