Send Emails

[camdonsquire]

Hi,

I have a list of email address's which i have stored from my website http://www.sense-pcs.co.uk. These email address's are stored in an Access database. I want to know how to send emails through access.

Lets just say....

I want to be able to select individual customers, then send the selected customers an email; advert/special offers, changes to the website etc....

If there is code already created then great, if not can any one point me in the right direction.



Donny Smart

 

[crow]

Email in Access

I have used this code to send emails from Access. What it does is uses your default email client to send an email to the name that is in a text field called username. You could have your list in a drop down box and choose one to send an email. I used this code on a button to activate the email client. Hope this helps.

DoCmd.SendObject acSendNoObject, , , Me.username, , , "Testing Email"

 

[BukHix]

Here are three threads that should provide everything you need to do what you want.

Access Email Question

Automatic Emailling from Access 97

Emailing Reports