Send Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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