Send Report

P

pjscott

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

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

acSendReport Problem 0
Send Email 4
Label's Caption Issue 3
Add 31 records w/ consecutive dates w/ command button? 2
Need X to act like my "Close without Save" button. 5
Run-time Error 5 "Invalid Procedure Call or Argument" 1
Report using subform Order By and Filter values 1
Problem Moving to New Records 1

Top