Reply
 
Thread Tools Display Modes
  #1   Report Post  
Hotsauce
 
Posts: n/a
Default MailMergeToEmail.Bas

I picked up this extremely useful VBA Macro on the MVPS.org website. I think
I have enabled the correct Office Outlook Ojbest Library, and I have imported
and associated the macro with the main program. However, whenever I try to
run the macro I get an error popup saying that the macro is disabled.

I have checked the security settings, and for macros they are set to
medium... meaning that it should prompt me for next action when it doesnt
trust a macro or add-in. I have about exhausted my options here. Can anybody
shed any further light on this?

(I had this problem once before, on another computer, however - after
fiddling with the Design Mode settings it went away by itself. I never really
figured out what caused it or what made it go away.)

Thanks much! I have spent hours on this without much success.

Roger
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

Where do you have the macro? It needs to be in either the normal.dot
template or an add-in which is a template that you would save in the Word
Startup directory.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Hotsauce" wrote in message
...
I picked up this extremely useful VBA Macro on the MVPS.org website. I
think
I have enabled the correct Office Outlook Ojbest Library, and I have
imported
and associated the macro with the main program. However, whenever I try to
run the macro I get an error popup saying that the macro is disabled.

I have checked the security settings, and for macros they are set to
medium... meaning that it should prompt me for next action when it doesnt
trust a macro or add-in. I have about exhausted my options here. Can
anybody
shed any further light on this?

(I had this problem once before, on another computer, however - after
fiddling with the Design Mode settings it went away by itself. I never
really
figured out what caused it or what made it go away.)

Thanks much! I have spent hours on this without much success.

Roger



  #3   Report Post  
George Lagger
 
Posts: n/a
Default

In Security settings there must be a checkbox indicated as smth like 'Grant
access to VB Project' (may be a bit different since I use a localized version
of Word). I'm not a Pro, but this could be of help

"Hotsauce" пишет:

I picked up this extremely useful VBA Macro on the MVPS.org website. I think
I have enabled the correct Office Outlook Ojbest Library, and I have imported
and associated the macro with the main program. However, whenever I try to
run the macro I get an error popup saying that the macro is disabled.

I have checked the security settings, and for macros they are set to
medium... meaning that it should prompt me for next action when it doesnt
trust a macro or add-in. I have about exhausted my options here. Can anybody
shed any further light on this?

(I had this problem once before, on another computer, however - after
fiddling with the Design Mode settings it went away by itself. I never really
figured out what caused it or what made it go away.)

Thanks much! I have spent hours on this without much success.

Roger

  #4   Report Post  
Hotsauce
 
Posts: n/a
Default

Thanks Doug

That one was not obvious at all. I moved the macros from the project .dot to
the normal.dot area. I also closed all VB and MW windows and then reopened
everything. One, or the other, solved the problem. One of the local people
here thought that any changes to the security settings (I had changed the
security setting from the default "high" to "med"
) would not take effect until you close all windows and reopen. Also, come
to think of it: when the macros were in the project area I would have to
reload them each time.

Thanks again,

Roger

"Doug Robbins" wrote:

Where do you have the macro? It needs to be in either the normal.dot
template or an add-in which is a template that you would save in the Word
Startup directory.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Hotsauce" wrote in message
...
I picked up this extremely useful VBA Macro on the MVPS.org website. I
think
I have enabled the correct Office Outlook Ojbest Library, and I have
imported
and associated the macro with the main program. However, whenever I try to
run the macro I get an error popup saying that the macro is disabled.

I have checked the security settings, and for macros they are set to
medium... meaning that it should prompt me for next action when it doesnt
trust a macro or add-in. I have about exhausted my options here. Can
anybody
shed any further light on this?

(I had this problem once before, on another computer, however - after
fiddling with the Design Mode settings it went away by itself. I never
really
figured out what caused it or what made it go away.)

Thanks much! I have spent hours on this without much success.

Roger




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 03:36 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"