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:
[email protected]
To:
[email protected]
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.
