Send a group email (1 Viewer)

[mistermarty]

Hi all.

I have a customer database, where some of the customers have recorded an email address and some haven't. The customers fall into 20 different groups within the DB.

My question is, can I create a button on an existing form, whereby when it is clicked it asks for me to input which group I need to email, and then it will automatically open up an email application (Outlook) and insert the email addresses from any customer within that group that has recorded an email address in the Bcc address section? If so, how do I get started?

Thanks

 

[Uncle Gizmo]

This might give you a start:-

Display Field Data Horizontally - Nifty Access

Transform, Concatenate Examples A common requirement in MS Access is to extract Columnar data into horizontal data, for instance to make reports look better, to provide a list of emails suitable to send to with Outlook. In the YouTube videos below I explain how this can be done. Display Field...

www.niftyaccess.com

 

[theDBguy]

Hi. For constructing the entire email address for Outlook, you might be able to use this.

Code Snippets

Hope that helps...