Is it possible to send blanket emails to contacts in an Access DB.

[Guest]

I have an access db on a server and would like to create some kind of script
that will take text from a file (message), put it into the body section of an
email and send it to each email address in my db. Is this possible via
stored procedure or otherwise?

 

[Mike Labosh]

From a Stored Procedure: I have heard of something in Sql Server called
"SendMail", but I don't know what it is or how it works:

From Access VBA: You can set a reference to Microsoft Outlook and use the
Outlook objects to send email, but you will require a "from" address that is
a valid account on your network. There is also another object library you
can use: CDO or Microsoft Collaboration Data Objects (I think that's what
it stands for) and CDO requires an Exchange Server on your local network.

From VB.NET, You can set a reference to System.Web.Mail and use the SmtpMail
and/or MailMessage classes.

An outgoing mail message is formatted like this:

From: (e-mail address removed)
To: (e-mail address removed)
Subject: Here's a message
Body: Here's the content of my message

With each line terminating with a LF (ASCII 11 Character), not a vbCrLf.
Anything after Body: is assumed to be the body of the email. If you write
this to a file and then move the file to the "Drop" folder of an SMTP Server
(typically c:\inetpub\mailroot\drop at the server) then the server will try
to send it. I don't know how to do attachments this way though.

If you are insane, you can built TCP-IP packets and send them to port 25 of
the server.