Email via Macro (MS Outlook) 1

[stewm]

Hello,

I'm trying to automate the emailing of an Impromptu report saved in Excel format. Everything is working fine except for when I run the macro it states the following...

A program is trying to automatically send email on your behalf. Do you want to allow this?

If this is unexpected, it may be a virus and you should choose 'NO'.

I what to schedule this macro to run automatically. I do not want to have to be around to choose 'YES'.

The email is being sent through MS Outlook. Is there a way to bypass this annoying little validation check?

Thanks



Mark Stewart
Senior Analyst
Consultants Club Corp.
Windsor, Ontario
Canada

http://www.consultantsclub.biz

 

[griffindm]

Mark,

What is happening is Exchange Server is preventing automated emailing through Outlook due to a security policy. There is some discussion about this here, which should be able to be searched using the "CDO" keyword. I'd check with the Exchange security IT people and see if they can change the rule for the group the user is in that needs to run the macro.

Hope this helps.

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com