Send Report

P

pjscott

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

DoCmd.SendObject acSendReport, "rptWorkOrderData", acFormatRTF,
"[email protected]", "", "", "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
 
S

SFAxess

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