Hi, I have created a workbook and now I would like to have access attach the workbook in an email. I can execute it when it's sending a query but I can seem to find anything that will send an excel workbook. Here is the code for the query.
DoCmd.SendObject acSendQuery, "PCF Automated Agency Checklist Report", acFormatXLS, "kristy@gmail.com", , , "Agency Checklist", "Attached is the report you requested", True
The report I need to send is located in this file path
"C:\Users\kristy\Documents\PCF Report.xls"
can someone help me replace the code for the query with the code for the Excel workbook?
Thanks in advance!