hello all
I've worked out this very simple function in order to send a report by email
Code:
Public Function send_email(email_to As String, Optional email_cc As
String, Optional bc As String, Optional email_object As String, Optional email_text As String, Optional email_attach As String)
On Error GoTo Err_send_email
DoCmd.SendObject _
acSendReport, _
email_attach, _
acFormatHTML, _
email_to, _
email_cc, _
email_bc, _
email_object, _
email_text, _
False
Exit_send_email:
Exit Function
Err_send_email:
MsgBox Err.Description
Resume Exit_send_email
End Function
everything seems working fine to me except the fact that I get an annoying security notice (I'm using Outlook Express 6): "A program is trying to access e-mail addresses you have stored in Outlook. Do you want to allow this?"
Is there a way to programmatically (by vba code) work aroud or switch off this useless (and confusing for the end user) kind of warning?
I've been searching around in the web and in this forum but I could not find a proper solution also because I would not (in fact I can not) rely on third party utilities?
thanks for any help
max
ps I know also about the "partial solution of the problem" by going into the Outlook Express menu tools->options->security... and so on...