Private Sub Command0_Click() On Error GoTo Command0_Click_Err DoCmd.SendObject acTable, "tblAction_Type", "", "[email protected]", "", "", _ "What ever you want", "body of the message", False, ""
Command0_Click_Exit: Exit Sub Command0_Click_Err: MsgBox Error$ Resume Command0_Click_Exit End Sub --- On Thu, 4/16/09, John McGovern <[email protected]> wrote: From: John McGovern <[email protected]> Subject: [Access VBA Central] email Reports To: [email protected] Date: Thursday, April 16, 2009, 12:13 PM Hi to all, I am new to the Group, and sure this question has been posted before, but I did a quick search and did not find the right answer. I want to email customer invoices from Access 97 via Automation. I have tried using the Send command of the File menu, but the report is not formatted correctly and the process is not automated anyway. - What is the best format / software to do this - pdf, HTML, other? -And then, on the email side; can it too be automated? Suggestions? Thanks to all, -John [Non-text portions of this message have been removed]
