[AccessD] Route email to SMTP Server from Access

You could also UUencode it.  The algorithm can be found here (a vb
implementation that can easily be converted to Access VBA): 
http://www.vbip.com/winsock/winsock_uucode_01.asp

Note that I have not tested this code.

Also, you can email via SMTP using sockets.  You do not have to have CDO to
use sockets. You can use the Winsock object (I think it is an activeX
control) to do this.

HTH
Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Monday, December 22, 2003 7:07 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Route email to SMTP Server from Access


Um, attachments....that is going to involve MIME formatting.  The Winsock
control just 'talks' to the SMTP server.  You give it the server to talk to,
the address from and to, and then you give it 'the data', which is the
entire email (attachments and all).  Already posted the code a few posts
ago.

Drew