John, Create the query as a static one that requires the user to answer all of the questions prior to clicking on the button. Merrick
--- On Sat, 4/18/09, [email protected] <[email protected]> wrote: From: [email protected] <[email protected]> Subject: Re: [Access VBA Central] email Reports To: [email protected] Date: Saturday, April 18, 2009, 11:07 AM 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 <mswatch...@yahoo. com> To: AccessVBACentral@ yahoogroups. com 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" , "", "mswatch...@yahoo. com", "", "", _ ???????????? ????????? ???????? "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 <jmlt...@aol. com> wrote: From: John McGovern <jmlt...@aol. com> Subject: [Access VBA Central] email Reports To: AccessVBACentral@ yahoogroups. com 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] [Non-text portions of this message have been removed]
