Email Report from Access

Hi,

I have a button a form with combo boxes to filter my data by Year, Month and Supervisor to a report, this works fine.
I want to email out the same report from a button but it is not picking up the report parameters from the combo boxes, it just emails all the data in the system.
The command line I have under the email button is:

Private Sub cmdEmailReport_Click()
DoCmd.SendObject acSendReport, "ReportMissingDL", "PDF Format (*.pdf)"
End Sub

Is there are way to email this same report out??

Thanks

This is an older link on how to email from Access. You may still find it helpful.

http://www.datapigtechnologies.com/f...sendemail.html

Hi Alansidman,

Sorry for the late reply , I was side tracked on another project.
This link was very helpful!!
Thanks