Query output to Outlook Distribution list

[thegrimmerdiscovery]

Hello people



Is there a simple way of populating an Outlook email 'To' field from the series of email addresses produced by an Access query?

If there is - how?

Thanks

[June7]

Simple answer is: Yes with VBA.

Open a recordset object and loop through records and concatenate addresses.

This is a common topic and there are many discussions and examples.

[Minty]

Not really - you would need to loop through the query recordset results and build the to; string from the email addresses.
There are loads of examples here this has one method https://www.accessforums.net/showthread.php?t=4287 and look at the bottom of that thread for other examples.

If it's not internal I would recommend using the BCC: field instead of To: as it hides the addresses from the recipients.

[thegrimmerdiscovery]

thanks for the responses people. I shall have a delve