Sending Email from Access - How?

  • Thread starter Thread starter Forest
  • Start date Start date
F

Forest

Hi,

How can I send emails from access database of my
contacts? Using Access 2000 on WinME, 800mhz PC. I use
Outlook Express 5 mostly but have Outlook 2000 too.

I want to send email to my Access contact base of about
600 people.

Preferably it would be HTML enabled email, so I could
retain links and formatting.

THanks,

Forest
 
Forest said:
Hi,

How can I send emails from access database of my
contacts? Using Access 2000 on WinME, 800mhz PC. I use
Outlook Express 5 mostly but have Outlook 2000 too.

I want to send email to my Access contact base of about
600 people.

Preferably it would be HTML enabled email, so I could
retain links and formatting.
Click to expand...

Well, you've got some conflicting goals here.

SendObject is the simplest way to send Email in Access. But that was
essentially "broken" in Access 2000 unless the later service packs resolved
the problems. Also you can't do anything but a plain text message with
SendObject.

You could Automate Outlook and send HTML messages, but you can't automate
Outlook Express to do this. You can automate the CDO libraries, but that
means you are stuck with plain text messages again.

See link below for sample code for doing the last two above.

http://www.mvps.org/access/modules/mdl0019.htm
 
OK thanks for your reply and assistance,

In fact, I think I confused the question a bit too. What
I really want to be able to do is have Access act as my
email manager/address book, and send pages I create in
WORD or other program saved as HTML. Afterall, what good
is it to have a database of emails, if you cant do
anything with them? Or I'm missing something.

It doesn't sound promising, but thanks for the info:)

Forest
 
Forest said:
In fact, I think I confused the question a bit too. What
I really want to be able to do is have Access act as my
email manager/address book, and send pages I create in
WORD or other program saved as HTML. Afterall, what good
is it to have a database of emails, if you cant do
anything with them? Or I'm missing something.
Click to expand...

If you want to control everything yourself then you want to use a
third party control. See the appropriate section at 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
 
Thanks Tony, I will check your site out!

Forest
-----Original Message-----


If you want to control everything yourself then you want to use a
third party control. See the appropriate section at 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
.
Click to expand...
 
Dim Body As String
Dim COCI
Set COCI = CreateObject("Outlook.application").CreateItem(0)

Body="Some String Stuff"

COCI.to = (e-mail address removed)
COCI.cc = (e-mail address removed)
COCI.subject = "Test"
COCI.Body = Body
COCI.deleteAfterSubmit = True
COCI.send
 
Back
Top