Microsoft Access

[steven21]

Hi Guys,

I was wondering if it is possible to extract e-mail addresses from a database in MS Access so I can then send a mass e-mail to members who have joined an organisation.

I am getting information from a contact form and manually typing it in to an Access D/B - each member receives an auto reply advising there email has been sent, but is it possible to run anything to get the emails and then send an email to these to confirm membership has been added?

I will just be using my own email. currently I will be copying and pasting email addresses but I need something more productive.

No mass emailer

[sladmin]

The way I usually do this is to add the data from the signup page to the database, and when it has been inserted, send both yourself and the user an email.

I'm not entirely sure what you mean to do here though, perhaps you could expand on this? For example, Do you want to create a signup feature where you want users to receive an email with a link so they can validate their account?

[Ben Collier]

http://msdn2.microsoft.com/en-us/library/aa159619(office.11).aspx

I think the whole thing is over complicated but this is how it's done, alternatively you could try exporting the data in a csv list, with a ; in between each address and paste that into the bcc and set yourself as the recipient.

Ben