Sending email from within Access??

I am developing a small database at work and was after some help if anyone could oblige!

Currently we store the usual information on clients - name, address, email etc. My query is that
is there anyway of opening Outlook (or similar) with an email address already in the 'To:' and a
subject in the 'Subject:' part of the email. Or is there anyway of writing and sending an email
from within Access? Currently I am just using a RunCommand to open Outlook and it is tiresome
to have to flick between Outlook and Access to write the email address.

Cheers!

Rob

Install the Outlook reference library and use Acces to generate emails by Outlook. I have done this many times. Search the MS website for sample code.

activate the outlook reference library and do look at the following for guidance:

Dim myOlApp as object
Dim myEmail as outlook.mailitem

Set myOlApp = CreateObject("Outlook.Application")
Set myEmail = myOlApp.CreateItem(olMailItem)

With myEmail
.To = Me.EmailAddress
.Subject = "This is an email"
.Body = "Type email here"
End With
myEmail.Display




Hope this helps
Andy