SendObject format

  • Thread starter Thread starter J.Bennett
  • Start date Start date
J

J.Bennett

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", , , ,
,"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
 
On Mon, 15 Mar 2010 23:16:01 -0700, J.Bennett

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
 
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 said:
On Mon, 15 Mar 2010 23:16:01 -0700, J.Bennett

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", , , ,
,"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[/QUOTE]
.
[/QUOTE]
Click to expand...
Click to expand...
 
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 said:
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 said:
On Mon, 15 Mar 2010 23:16:01 -0700, J.Bennett

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", , , ,
,"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[/QUOTE]
.
[/QUOTE][/QUOTE]
Click to expand...
Click to expand...
Click to expand...
 
Hi, I have been hunting everywhere for the coding (And am totally exhausted) so I can simply click on a button on a form or report that will email that record as a pdf. You seem to have figured it out. Would you mind ever so kindly helping me out and posting your code. Im a new user and am totally bewildered. I can get a print screen or a send object converting to pdf and emailing but it sends the entire report. I need the code so I can email just the current record. All I find is quick short replies to this question but Im a new user and would appreciate step by step and code if you have the time. Thanks in advance
Julie

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", , , ,
,"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
[QUOTE]
On Tuesday, March 16, 2010 9:42 AM Tom van Stiphout 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[/QUOTE]
[QUOTE][/QUOTE]
[QUOTE][QUOTE]
On Wednesday, March 17, 2010 7:29 PM J.Bennett wrote:
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:[/QUOTE][/QUOTE]
[QUOTE][/QUOTE][/QUOTE]
Click to expand...
 
Hi, I have been hunting everywhere for the coding (And am totally exhausted) so I can simply click on a button on a form or report that will email that record as a pdf. You seem to have figured it out. Would you mind ever so kindly helping me out and posting your code. Im a new user and am totally bewildered. I can get a print screen or a send object converting to pdf and emailing but it sends the entire report. I need the code so I can email just the current record. All I find is quick short replies to this question but Im a new user and would appreciate step by step and code if you have the time. Thanks in advance
Julie

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", , , ,
,"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
[QUOTE]
On Tuesday, March 16, 2010 9:42 AM Tom van Stiphout 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[/QUOTE]
[QUOTE][/QUOTE]
[QUOTE][QUOTE]
On Wednesday, March 17, 2010 7:29 PM J.Bennett wrote:
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:[/QUOTE][/QUOTE]
[QUOTE][/QUOTE]
[QUOTE][/QUOTE][/QUOTE]
Click to expand...
 
Hi, I have been hunting everywhere for the coding (And am totally exhausted) so I can simply click on a button on a form or report that will email that record as a pdf. You seem to have figured it out. Would you mind ever so kindly helping me out and posting your code. Im a new user and am totally bewildered. I can get a print screen or a send object converting to pdf and emailing but it sends the entire report. I need the code so I can email just the current record. All I find is quick short replies to this question but Im a new user and would appreciate step by step and code if you have the time. Thanks in advance
Julie
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", , , ,
,"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
[QUOTE]
On Tuesday, March 16, 2010 9:42 AM Tom van Stiphout 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[/QUOTE]
[QUOTE][/QUOTE]
[QUOTE][QUOTE]
On Wednesday, March 17, 2010 7:29 PM J.Bennett wrote:
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:[/QUOTE][/QUOTE]
[QUOTE][/QUOTE]
[QUOTE][/QUOTE]
[QUOTE][/QUOTE][/QUOTE]
Click to expand...
 
Back
Top