<div>
Where would the list of emails come from?
</div>


<div>
They are already setup in Office 365 as Distribution Lists so they exist, but as to where they would come from, I have no idea that is why I am asking the best possible way to accomplish my goal.<br />
<br />
<br />
What would you suggest?
</div>


<div>
This is a trivial problem as long as the distribution lists exist in a table so you can use a query to read the list and send an email for each item. &nbsp;If the Lists are somewhere that Access can get to, you might be able to do this with VBA but it will be more code than you sound like you would be comfortable with.
</div>


<div>
This is not a trivial task. <br />
<br />
For a static extraction of the members of the list, this previous question answers how:<br />
<br />
<a href="https://www.experts-exchange.com/questions/28925209/How-to-export-all-members-of-a-distribution-list-from-office-365.html" rel="ugc">How to export all members of a distribution list &nbsp;from office 365</a><br />
<br />
For a dynamic extraction - if members change frequently - you would have to call a similar script, read the members, and somehow have them listed for the user to mark and unmark.
</div>


<div>
Or, you can simply change the last argument of the SendObject method to True. &nbsp;This will actually open the email in your email application, and you can type in the select distro list (although this is not nearly as elegant as displaying some form of popup to select from distro lists which exist in Outlook).<br />
<br />
Dale
</div>


<div>
@PatHartman - Would you be able to point me in the right direction to accomplish that?<br />
<br />
@Gustav Brock - Not sure why it would need to extract the members of the Dist List as it does not do that now and works fine, I just want to be able to have the user select between two different Dist Lists.<br />
<br />
@Dale Fye - &nbsp;That may be the course I go, I was also thinking of duplicating the script and placing a second button on the form for them to select for the other Dist List
</div>


<div>
I'd like to but I don't where your list is currently so I can't tell you how to import it. &nbsp;Access does have the ability to link to Outlook and so if your list is in Outlook You can just link to it and use it like a table -- External Data/New Data Source/From Other Sources.<br />
<br />
If you want the user to select more than one email, then you can bind the linked contact list to a multi-select listbox and that can be used to control the send loop. &nbsp;If you just want the user to select one email, then use a combobox or listbox in single select. &nbsp;That will not require a loop. &nbsp;Your OutputTo command will just reference the combo/listbox for the single address.
</div>


<div>
I created a new table in the db called Email_Address and listed the two email addresses in there how can I query that and then present for selection?
</div>


<div>
Add a combo to your form. &nbsp;The RowSource of the combo would select the table with the email addresses. &nbsp;You can use the BeforeUpdate event of the combo to run the OutputTo command. &nbsp;Just reference the combo in the part where you need the email address.
</div>


Manager, Information Systems

haradaindustryofamerica

<div>
That's fine but if you add a third address, my suggestion requires NO code or form changes. &nbsp;However, your solution will require code and form changes. &nbsp;Try to take off your spreadsheet hat and put on your relational database hat. &nbsp;Additional data values should NEVER, EVER affect any design element in a properly designed application whereas in a spreadsheet, each time you add a new data value, you have to change all your formulas to accommodate the new value.
</div>


<div>
<div class="content wysiwyg-content">
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. &nbsp;Below is my code for sending the form.<br />
<br />
strDocName = &quot;PReport&quot;<br />
&nbsp; &nbsp; strFilter = &quot;DQR ='&quot; &amp;&nbsp;Me!DQR &amp;&nbsp;&quot;'&quot;<br />
&nbsp; &nbsp; DoCmd.OpenReport strDocName, acViewPreview, , strFilter<br />
&nbsp; &nbsp; DoCmd.SendObject acSendReport, &quot;PReport&quot;, &quot;PDF Format&quot;, &quot;New-HIX-DQR@company.com;&quot;<wbr />, &quot;&quot;, , &quot;New DQR&quot;, &quot;Please see the latest DQR issued by HIA QA&quot;, , False
</div>
</div>


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

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

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.