[AccessD] Route email to SMTP Server from Access

I never saw my reply come through so I'm re-posting...
you can always BLAT your email, here is a small sample database...

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Tapia,Francsico

-- 
-Francisco


paul.hartland at fsmail.net wrote:

>Have you looked at vbSendMail it's free to download.  It sends email straight to the SMTP server and works in VB6 like a charm.  I'm sure it can be used in Access (may be worth looking into)
>Paul Hartland
>
>
>
>
>
>Message date : Dec 17 2003, 08:50 PM
>>From : Erwin Craps - IT Helps 
>To : Access Developers discussion and problem solving 
>Copy to : 
>Subject : RE: [AccessD] Route email to SMTP Server from Access
>You could consider buying some ActiveX controls that do the job for you.
>I bought several years ago the ip works kit for VB/VBA.
>They have SMTP/MIME conrols etc...
>Using an SMTP server directly does mean more work. For example if you
>would need to add attachements then you need to mime this. Further more
>you can run into firewall problems at customer site..
>
>Erwin
>
>
>-----Oorspronkelijk bericht-----
>Van: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] Namens Dan Waters
>Verzonden: woensdag 17 december 2003 20:55
>Aan: Database Advisors
>Onderwerp: [AccessD] Route email to SMTP Server from Access
>
>Hello and Happy Holidays to everyone!
>
>I have a customer I am getting started with. To send email and get
>around the Outlook security patch, I suggested either using Redemption
>or using the Outlook Security Administrator's package. I then received
>the suggestion to try sending email straight to the SMTP server,
>bypassing the security problem. 
>
>What seems to be required to do this is to either use CDO, of which
>there are different versions (CDO, CDONTS, and CDOSYS), or a 3rd party
>product.
>Is this really correct or is there another way? Perhaps a Windows API
>that can be used for the same purpose?
>
>I did do a search on the archives for SMTP, but because many people's
>emails have SMTP in the email header, the search was not useful.
>
>Anyone have an early Christmas present they can give me?
>
>Thanks!
>Dan Waters
>Quality Process Solutions.
>  
>