View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
blackbox via OfficeKB.com blackbox via OfficeKB.com is offline
external usenet poster
 
Posts: 59
Default Avoid Outlook macro security for Excel bades macro

I wasn't sure where I sould post this so i'm postin in the Excel and Outlook
forums.

I have a macros in excel that generate emails in Outlook. As it is now, I
press a command button which generates the email and I then have to press
Send on each.

When I change the macro from .Display to .Send, Outlook's security catches it
and after several seconds displays a message box staiting that "A program is
attempting to send an email on your behalf. Do you want to continue?"

It kind of defeats the purpose of the .Send command, especially since it's
slower than displaying the email and hitting the send button.

I don't want to shut off the macro security completely.

Is there a way to authorize specific macro to run without the security pop-up?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1