I've been successful with sending an email from Access 2007 with a .pdf attachment to a single recipient using the following:
DoCmd.SendObject acSendNoObject, "C:\Report\Report1.pdf", acFormatPDF, "JohnDoe@Company.com", , , "Report", "Report file attached.", False
I need to send the same report to multiple recipients ( Table: tblEmailAddress, Field: "Address"). What is the best method (ie String, Loop) and can you provide a sample?