Hi--I am using Access 2007 and want to automatically email reports that are generated in Access through Outlook.
I have all of the steps down--running the queries, populating and formatting the report, attaching the report and having the reciepients and message text ready to go--all running as macros. However, when the Outlook window opens, I still have to click "send." I do not want to have to click the send key. Is this new to Access/Outlook 2007/2010? An Outlook issue ? Exchange?
My OS is Windows 7 Professional.
Here is the sample macro code converted to VB:
Option Compare Database
'------------------------------------------------------------
' Macro1
'
'------------------------------------------------------------
Function Macro1()
On Error GoTo Macro1_Err
DoCmd.SendObject acTable, "Table1", "", "recipient@recipient.com", "", "", "", "", True, ""
Macro1_Exit:
Exit Function
Macro1_Err:
MsgBox Error$
Resume Macro1_Exit
End Function
Thanks!