I wanted to send a copy of a report in pdf format to an email address and I thought the code would be:
DoCmd.SendObject acSendReport, "WorkOrderFinalR", acFormatPDF, "email@email.com", , , "New Work Order TEST", , False
And it works, except it sends me all of the reports, not just the one from the form that was submitted. But there's no place for a where condition in the code. My query feeding the report I want to send is attached in the picture.
DoCmd.SendObject acSendReport, "WorkOrderFinalR", acFormatPDF, "email@email.com", , , "New Work Order TEST", , False
And it works, except it sends me all of the reports, not just the one from the form that was submitted. But there's no place for a where condition in the code. My query feeding the report I want to send is attached in the picture.
