Recent content by jlilwall

Thanks for your replies, my main issue is getting access to insert the appropriate contact address and then table into each email, I believe its with this line of code: DoCmd.SendObject acSendTable, TblName, acFormatXLS, ArrayPersonName(0, n), , , StrSubject, StrMsg & StrMsg1, True

Hi All, I have been grappling with this for a little while. I have this piece of code in my access database which currently looks for records which meet a certain criteria (set in mt Report_review_documents) and then emails the individuals within that query a list of their records (as an...