I am finally able to e-mail a query to multiple recipients, but now I am getting an security warning from outlook.
Is there a way I can add some code to below code to avoid this message?
Private Sub Command32_Click()
DoCmd.SendObject acQuery, "Sales Report", acFormatXLS, "joe@hotmail.com", "", "", "Sales report", "see attached spreadsheet", False, ""
End Sub
Is there a way I can add some code to below code to avoid this message?
Private Sub Command32_Click()
DoCmd.SendObject acQuery, "Sales Report", acFormatXLS, "joe@hotmail.com", "", "", "Sales report", "see attached spreadsheet", False, ""
End Sub