In Access db when a user clicks the Mail Report button on a form an email is created and populated with the information to send to a Distribution List. I would like the user to be presented with a list of email addresses to be able to select from, how do I do that. VB newbie. Below is my code for sending the form.
strDocName = "PReport"
strFilter = "DQR ='" & Me!DQR & "'"
DoCmd.OpenReport strDocName, acViewPreview, , strFilter
DoCmd.SendObject acSendReport, "PReport", "PDF Format", "New-HIX-DQR@company.com;", "", , "New DQR", "Please see the latest DQR issued by HIA QA", , False