Using emails addresses in access to send a mass email to
in [Forms]
|
Prev: Query to show all records when a value in a record has been entered
Next: delete button deletes the wrong thing
From: Colin Weir on 10 Feb 2010 06:44 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
From: Arvin Meyer [MVP] on 10 Feb 2010 09:49 Try this code if you are using outlook: http://www.datastrat.com/Code/MultipleEmail.txt -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Colin Weir" <colin.weir(a)blueyonder.co.uk> wrote in message news:2ce77bf5-a6a8-43d7-acdc-4fc7e400a645(a)j31g2000yqa.googlegroups.com... > 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
From: Lars Brownies on 10 Feb 2010 11:48
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 "Colin Weir" <colin.weir(a)blueyonder.co.uk> schreef in bericht news:2ce77bf5-a6a8-43d7-acdc-4fc7e400a645(a)j31g2000yqa.googlegroups.com... > 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 |