Prev: Retrieving @@Identity value in ado.net
Next: OJG;mlorAM
From: J.Bennett on 16 Mar 2010 02:16
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
From: Tom van Stiphout on 16 Mar 2010 09:42
On Mon, 15 Mar 2010 23:16:01 -0700, J.Bennett
<JBennett(a)discussions.microsoft.com> 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 here:
http://office.microsoft.com/en-us/access/HA101675271033.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
From: J.Bennett on 16 Mar 2010 21:29
Tom, Thanks for the reply. However, your recommendation doesn't work for me
as using a button on the form does not filter the records. I get the report
for every record in the querry. I navigate from one form to another by
filterning down to the record in use. I have one form for building
information, one for pricing, and finally one for the customer information if
they decide to purchase the portable building. I have a button that runs an
event that does a print preview for the current record. If I follow the
DoCmd for the preview with the DoCmd SendObject, I get the email with the pdf
attached for the one record. The problem is that the user is prompted for
the format type (html, text, pdf,...etc.). I would like to elimate the user
from having to select the pdf option.

If I make a button to run a macro, I can add all the information including
format, subject, text, etc. It all works well, except it has every record in
the querry.

I have also downloaded the latest add-ons as referenced in your email. I
have no problem with creating the pdf, just creating the pdf limited to the
current record.

Again, I would be happy if I can simply eliminate the need for the user from
having to select the format type.

Any additional informaiton/suggestions would be appreciated.

"Tom van Stiphout" wrote:

> On Mon, 15 Mar 2010 23:16:01 -0700, J.Bennett
> <JBennett(a)discussions.microsoft.com> 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 here:
> http://office.microsoft.com/en-us/access/HA101675271033.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
> .
>
From: J.Bennett on 17 Mar 2010 19:29
I finally figured this out. I am posting in the event others find it useful.
The information for on-line help regarding this function, a link is provided
as follows:

http://www.fmsinc.com/MicrosoftAccess/Email/SendObject.html

This was the most helpful information regarding the SendObject function I
found. I provided the syntax for the available [Format] for converting to
pdf (which by the way is acformatpdf). Additionally, if the "Embedded Macro"
is used, the option to edit the email before sending is either YES or NO.
The correct syntax is actually TRUE or FALSE. Using YES or NO does not work
properly.

In any case, my issue is resolved.

"J.Bennett" wrote:

> Tom, Thanks for the reply. However, your recommendation doesn't work for me
> as using a button on the form does not filter the records. I get the report
> for every record in the querry. I navigate from one form to another by
> filterning down to the record in use. I have one form for building
> information, one for pricing, and finally one for the customer information if
> they decide to purchase the portable building. I have a button that runs an
> event that does a print preview for the current record. If I follow the
> DoCmd for the preview with the DoCmd SendObject, I get the email with the pdf
> attached for the one record. The problem is that the user is prompted for
> the format type (html, text, pdf,...etc.). I would like to elimate the user
> from having to select the pdf option.
>
> If I make a button to run a macro, I can add all the information including
> format, subject, text, etc. It all works well, except it has every record in
> the querry.
>
> I have also downloaded the latest add-ons as referenced in your email. I
> have no problem with creating the pdf, just creating the pdf limited to the
> current record.
>
> Again, I would be happy if I can simply eliminate the need for the user from
> having to select the format type.
>
> Any additional informaiton/suggestions would be appreciated.
>
> "Tom van Stiphout" wrote:
>
> > On Mon, 15 Mar 2010 23:16:01 -0700, J.Bennett
> > <JBennett(a)discussions.microsoft.com> 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 here:
> > http://office.microsoft.com/en-us/access/HA101675271033.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
> > .
> >
 | 
Pages: 1
Prev: Retrieving @@Identity value in ado.net
Next: OJG;mlorAM