Using emails addresses in access to send a mass email to

[Colin Weir]

Hi there

On the database I have here we store people's email addresses where
possible. Is there a way I can send an email to all these addresses
without having to copy and paste each of them into the email window?

Thanks

Colin

 

[Arvin Meyer [MVP]]

Try this code if you are using outlook:

http://www.datastrat.com/Code/MultipleEmail.txt

 

[Lars Brownies]

Arvin's link shows how to aumatically send an email to each person
individually. If you want to send one (and only one) email to all persons
you can select and copy the email column of your table or query and paste it
into the 'To'-field in your email. Your emailprogram will automatically put
the ; between all emailaddresses.

You could also automate the process by looping through the table, create a
string with all the emailaddresses, and paste it to the clipboard or create
an email automatically with the addresses in it.

Lars