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.
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.
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
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
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
