Thank you Merrick, I have already explored the SendObject Method, however it lacks 2 important features:
1) Printed invoices are generated at run-time using the 'Where Condition' argument of the OpenReport Method (of the DoCmd Object) to specify a single invoice. Unless the invoice is printed, the report will not inherit the 'Where' Condition' in the Filter Property. Therefore, using the SendObject Method will send the last report printed, or will try to send all reports (several thousand) if the Filter Property of the report is blank. 2) The process is not completely automated. The email client prompts the user to send. Ideally, the User would elect to email (rather than print) the invoice and either it would be sent without prompt, or perhaps stashed in a que for batch emailing - without prompt from the mail client. What am?I missing here? Thanks, -John -----Original Message----- From: Merrick Watchorn <[email protected]> To: [email protected] Sent: Fri, 17 Apr 2009 6:24 am Subject: Re: [Access VBA Central] email Reports 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] [Non-text portions of this message have been removed]
