DoCmd.SendObject acSendReport

[GraeagleBill]

In testing a new function to email reports with the report embedded within the body of the email, I get only a portion of the report as an HTML attachment. The report has header, detail and footer sections that are comprised strictly of label and text box controls. The text box controls are a mix of bound and unbound.



This is my first attempt to use the acSendReport of SendObject. My email client's compose properties stipulate HTML and plain text. I have manually embedded HTML for years, so I'm not suspicious of compose properties. However, there are functions involved in the setting of Control Source in a few of the unbound text boxes.

It's my understanding that there are some restrictions with controls in a report. Am I expecting too much here?

(InvID is a global variable that the report picks up in its Open Event to set a RecordSource filter.)

InvID = 109
DoCmd.SendObject acSendReport, "rptInvitation", acFormatHTML, "wcsreno@gmail.com", , , "Spring Retreat", , False

[June7]

I just tried this with a simple report and it worked.

What do you mean by "setting of Control Source" - expression in textbox or VBA behind report?

What happens?

[GraeagleBill]

As output to a pdf (With the exception of the logo in the image control, all other controls are either text box or labels.)


As SendObject acReport
I get empty body with attachment:


The attachment open in Chrome:

[June7]

I can see the HTML does not retain graphics like a check box and data is not preserved. No idea why data is lost because works in my test.

[GraeagleBill]

I'll try an unbound report with simple text to see if there's something more fundamentally wrong.

[June7]

My test used a bound report with one textbox calling a public function. Works - all data is retained, even the calculated.