LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to avoid excel pop-up in macro Francesco Magagnino Excel Discussion (Misc queries) 3 September 8th 08 11:30 AM
Excel macro using email - Security warning from Outlook Andre Croteau Excel Programming 3 October 16th 06 08:50 PM
Macro needed to set macro security in Excel to minimum Carl Excel Programming 3 March 18th 06 03:36 PM
How can avoid the security Macro message ... John B Excel Discussion (Misc queries) 1 March 29th 05 07:43 PM
Passing variables from Outlook Macro to Excel Macro [email protected] Excel Programming 2 January 7th 05 10:07 PM


All times are GMT +1. The time now is 06:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"