S
Stephen
When creating a report, is there a way to create a continuous report? More
specifically, the reports are designed so that the report pages are of a
certain size (e.g. 8 1/2" x 11" Portrait). However, when creating HTML
pages, those pages can be virtually unlimited in length.
I am trying to set my Access Program with a quote creator. When creating
the quote, the format on screen and printing will be multiple pages (if the
quote is long enough). However, if I want to email the quote, I can do se
by "sending an object" through VB. See below:
Function macSendEmailQuote()
On Error GoTo macSendEmailQuote_Err
DoCmd.SendObject acReport, "RptQuoteSheet", "HTML(*.html)", "", "", "",
"Requested Quote From Company", "", True, ""
macSendEmailQuote_Exit:
Exit Function
macSendEmailQuote_Err:
MsgBox Error$
Resume macSendEmailQuote_Exit
End Function
The problem is that the effective email divides the pages into multiple HTML
attachments. If the quote is four pages long, it attaches 4 HTML pages. I
want to send only a single HTML attachment.
I figure there are two options:
1. Use a VB code to concatenate the HTML pages into a single HTML page
before attaching it to the email (I am not sure how to do this or if it is
even possible)
2. Create a EMAILREPORT object which is a report of unlimited length. (e.g.
22" for a two page quote, 33" for a 3 page quote). Of course, I believe
this might have a length limit.
Does anyone know how I might address this problem?
-Stephen
specifically, the reports are designed so that the report pages are of a
certain size (e.g. 8 1/2" x 11" Portrait). However, when creating HTML
pages, those pages can be virtually unlimited in length.
I am trying to set my Access Program with a quote creator. When creating
the quote, the format on screen and printing will be multiple pages (if the
quote is long enough). However, if I want to email the quote, I can do se
by "sending an object" through VB. See below:
Function macSendEmailQuote()
On Error GoTo macSendEmailQuote_Err
DoCmd.SendObject acReport, "RptQuoteSheet", "HTML(*.html)", "", "", "",
"Requested Quote From Company", "", True, ""
macSendEmailQuote_Exit:
Exit Function
macSendEmailQuote_Err:
MsgBox Error$
Resume macSendEmailQuote_Exit
End Function
The problem is that the effective email divides the pages into multiple HTML
attachments. If the quote is four pages long, it attaches 4 HTML pages. I
want to send only a single HTML attachment.
I figure there are two options:
1. Use a VB code to concatenate the HTML pages into a single HTML page
before attaching it to the email (I am not sure how to do this or if it is
even possible)
2. Create a EMAILREPORT object which is a report of unlimited length. (e.g.
22" for a two page quote, 33" for a 3 page quote). Of course, I believe
this might have a length limit.
Does anyone know how I might address this problem?
-Stephen