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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Send Email 2
Label's Caption Issue 3
Select a Report from a List 7
Time Display 6
'Delete' from ListBox command button 4
Problem Moving to New Records 1
Run-time Error 5 "Invalid Procedure Call or Argument" 1
multiple attachments 3

Back
Top