Bobby Heid
bheid at appdevgrp.com
Tue Dec 23 13:14:41 CST 2003
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