Message on Behalf

[Test]

Hello,

I am programming a VBA in Excells and I am getting the Error message "A
Program is trying to send an e-mail message on your behalf..." , please let
me know the code to eliminate this

Sheet4.Select
Cells.Select
Selection.Copy
Workbooks.Add
ActiveSheet.Paste

ActiveWorkbook.SendMail "(e-mail address removed)", "Test"

Thanks

 

[Sue Mosher [MVP-Outlook]]

See http://www.outlookcode.com/article.aspx?ID=52 for your options with
regard to the "object model guard" security in Outlook.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers

 

[Test]

Hi Sue,

I tried the link, but no luck. I need a VBA code in Excel to bypass the
error message

Thanks

 

[Les]

Hello,

You can download a programme that clicks yes for you from here, it is free....

http://www.snapfiles.com/get/clickyes.html