Wrox Programmer Forums
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 30th, 2006, 07:34 AM
Registered User
Join Date: Aug 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Send It macro in excel

Hi all

First tnx for a great page, it have helped me a lot

I have a question I hope some of you can help with, I have made a macro, witch sends an email but Excel comes up with a “A program is trying to send an email” – warning, how do I execute that warning

Hope you can help me

Kind regards

Old September 4th, 2006, 07:26 AM
Registered User
Join Date: Jul 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts

As far as i understand you received a warning trying to send a mail with a macro. That is due to security implemented into Outlook. To bypass this problem i used a freeware tool: Express ClickYes (http://www.contextmagic.com/express-clickyes/). Of course that bypass security control and any task is trying to send and e-mail is able to do (even viruses).


Old September 6th, 2006, 05:21 AM
Friend of Wrox
Join Date: Jun 2003
Posts: 173
Thanks: 0
Thanked 3 Times in 3 Posts

You could also have a look at programming with CDO (www.cdolive.com). It allows my computer to bypass the Outlook automation security settings although this could well be to do with the trusted status of CDO on my computer.


Similar Threads
Thread Thread Starter Forum Replies Last Post
Send Mail thru Excel Macro Abhinav Excel VBA 14 May 15th, 2011 04:02 AM
Macro to send an email with an attachment in it samputha Excel VBA 2 August 13th, 2009 09:12 PM
Excel Macro - Send Email and Attachments robmill101 Excel VBA 1 October 21st, 2008 08:10 AM
Need macro to send email via default mail program chutchinson Excel VBA 0 September 27th, 2007 09:28 PM
Outlook - Send and Print Macro Karen Long VB How-To 0 June 14th, 2005 03:19 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.