How can I send automatic emails from an Access 2000 database?

[Guest]

I have created an Access 2000 database which is shared by a number of users
on my company’s network. I would like to create a function in my database
that would allow users to send email notifications using a template and
addressing information stored on a data file to a next level person.

 

[John Nurick]

See Tony Toews's email FAQ at http://www.granite.ab.ca/access/email.htm

 

[David C. Holley]

Check out HELP in the OUTLOOK VBA Editor. Under OBJECT look for
MailItem. The article there will cover all of the properties of the
MailItem object including how to send HTML in the email. From within
Outlook, the VBA code is simply

Set appOutlook = CreateObject("Outlook.Application")
Set newMailItem = CreateItem(olMailItem)

with newMailItem
.To = [receipeint(s)
.Subject = [mail subject]
.Send
[or]
.Display
end with