Does any one know how to disable this option (A program is trying to send e-mail on your behalf. Stop this message.)
I'm trying to send an auto e-mail with Marco from MS Access.
I am executing this macro from VB.Net...
Dim objAccess As New Access.Application
objAccess.OpenCurrentDatabase("D:\TestMacro.mdb", False) ' Add the Access File Path
objAccess.DoCmd.RunMacro("Macro1") ' Replace Macro1 with the name of your macro
objAccess = Nothing
But every time that my script trying to send the auto e-mail, a security popup and saing "A program is trying to send automatically send e-mail on your behalf."
How can I stop this security warning? or how can allow my program to send an e-mail on my behalf?.
How to Disable this....
Thanks & Regards
Deepu M.IWednesday, November 29, 2006 11:50 AM
The problem is that the macro you're calling is using a high level email engine, probably calling Outlook directly or one of its DLLs, and this will trigger the anti-email-virus routine you're seeing. This security feature was added to Outlook years ago after the infamous 'Love Bug' virus.
The solution is to modify the macro where it uses a lower level email engine since this method won't be affected by what you do in your .Net code. If you use CDO or SMTP instead of Outlook this should take care of the problem. You may want to consult the appropriate VBA or Access forums for ideas on how to do this.Wednesday, November 29, 2006 2:28 PM
Jared Parsons MSFT wrote: If you just need to send mail but don't necessarily need to send it through Outlook, check out the System.Net.Mail namespace. It can send mail independent of having Office installed.
My macro application will create a Access report by using QUERY Object...
and next step is Sending that report by email (SendObject in Macros).
So In Vb.Net System Mail... How to send this EXCEL Report Dynamically . It
should be QUERY Object Report...
Thanks & Regards
Deepu M.IThursday, November 30, 2006 7:34 AM