Avatar of haradaindustryofamerica
Flag for United States of America

asked on 

DoCmd.SendObject but be able to have user select email address to send to

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
Microsoft OfficeMicrosoft AccessVBAVisual Basic Classic

Avatar of undefined
Last Comment

8/22/2022 - Mon