email in access

  • Thread starter Thread starter Mike
  • Start date Start date
Hi, I'd also like to know how easy it is to use access to
hold a customer database and then send emails groups of
people if their addresses are held in access rather than
outlook.

Cheers

Meg
 
You haven't been specific as to what level of email facility you want to use
but there are several ways I know of to send emails from Access.

The simplest way is to use the docmd.sendobject feature. This allows you to
send an access object such as a report as attachments although the
formatting is rather limited. You can send a simple message without any
attachment if you want to. This uses outlook to send the emails.

A more complex but more flexible way is to use CDO. This requires some
programming and unfortunately is operating system dependent, with various
versions of CDO applicable to various versions of windows.

A third alternative would be to use automation to control outlook, although
I have never done this.

Any of these would allow you to send emails to one or more addresses stored
in access tables.

Rod
 
Mike said:
Is it possible to email someone who is a member in a
access personel database?

See the Access Email FAQ at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top