A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

SendObject format



 
 
Thread Tools Display Modes
  #1  
Old March 16th, 2010, 07:16 AM posted to microsoft.public.access
J.Bennett
external usenet poster
 
Posts: 45
Default SendObject format

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
  #2  
Old March 16th, 2010, 02:42 PM posted to microsoft.public.access
Tom van Stiphout[_2_]
external usenet poster
 
Posts: 1,653
Default SendObject format

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

  #3  
Old March 17th, 2010, 02:29 AM posted to microsoft.public.access
J.Bennett
external usenet poster
 
Posts: 45
Default SendObject format

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
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

.

  #4  
Old March 18th, 2010, 12:29 AM posted to microsoft.public.access
J.Bennett
external usenet poster
 
Posts: 45
Default SendObject format

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/MicrosoftAcces...endObject.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
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

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.