Send Report

[Guest]

I’m trying to send a report through e-mail using the following code.

DoCmd.SendObject acSendReport, "rptWorkOrderData", acFormatRTF,
"(e-mail address removed)", "", "", "New Work Order", "", False, ""

When I click the button associated with the code I get the following error.

Run-time error ‘207’:

Invalid column name ‘EmailName’

Can anyone tell me what’s wrong with the code?

Thanks,

Paul

 

[Guest]

Sounds like the error is with the report object you are referring to in the
SendObject command. Make sure that the report has a valid record source and
all of the text box controls have valid controlsource settings.