Connect Outlook to Access DB 1

[waely]

Hi Guys,
I'm not sure if what I'm trying to do is possible.I'm collecting visitores information through a contact form and storing the data in access db. what I'm trying to do is use outlook express or Microsoft Outlook to send emails to those how have emails in my emails table in the database.

please inform if that something can be done or I need a special software....

thank you in advance.
wael

 

[dyarwood]

Use a module and VBA

Dim olmail As Object
Dim omess As Outlook.Application
Set omess = CreateObject("Outlook.Application&quot
Set olmail = omess.CreateItem(0)

With olmail
.Subject = "Subject"
.Recipients.Add "another@address.com"
.Body = "body as a string here"
.Send
End With

You will also have to reference outlook (MS Outlook) in access.

dyarwood