On Mon, 15 Mar 2010 23:16:01 -0700, J.Bennett
wrote:

Put a button on your form. Use the button wizard (Report Operations,
Mail Report) and it will create the embedded macro for you. There is
an argument for body text as well.
If it still does not work for you, you may not have the add-in
installed. Read up on that he
http://office.microsoft.com/en-us/ac...675271033.aspx

-Tom.
Microsoft Access MVP


I am using an event to send a report as a pdf attachment. However, I cannot
figure out the [OutputFormat] to use. I have tried every possible
configuration of "PDF Format (*.pdf)" that I can think of. Without having
the proper [Output Format], the user must select the pdf option when
prompted. My command I am using is:

DoCmd.SendObject acSendReport, "PrintAllOrderForms", , [email], ,
,"New Order", YES

The [Output Format] should follow the comma (,) after the "PrintAllOrder
Forms". Additionally, I cannot determine the where to include text for the
body of the email.

I am using ACCESS 2007. I belive the help information is all shown for
ACCESS 2003.

Can anyone help with the [Output Format]? I can live without the text being
added to the body of the email.

Exhausted From Trying!
James Bennett