is there a way to use an access database to send group emails

[Guest]

doing some work for a friend setting up a client database for her shop, she
needs to be able to send an email to remind people once a week when they're
appointments are for that week, is there anyway to use an exsisting access
database which contains the email addresses of the clients and the date of
their next appointment to send them an email semi automatically rather than
go through the diary and do it manually in outlook express (which is how she
does it at the moment)

Cheers Nic

 

[Guest]

Here's a code snippet to send an e-mail from Access:

DoCmd.SendObject , , , “[email protected]â€, , , “Message Subjectâ€,
“Message body here.â€, False

You can tie that code to a button click if you'd like, and use VB to
populate the e-mail, subject and body.