[AccessD] EMail recommendations

If SMTP is blocked or turned off in the server the SMTP routine doesn't
work.  Usually with no indication that it isn't sending the email.

Perry 
 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Monday, February 15, 2010 11:45 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] EMail recommendations

Tony,

  I've used this code:

http://www.freevbcode.com/ShowCode.Asp?ID=109

  which sends e-mail directly via SMTP server. Although it is marked for
VB6, it works fine in VBA unmodified.

  As for the SMTP server IP, you can often discover the IP by doing a
poll of the MX records for the DNS entry.  There is some code in there
for that as well.

  From my viewpoint, that's about as simple as it gets; no client
dependencies, one .DLL to drop in the app directory, and just
discovering the SMTP server IP.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
Sent: Sunday, February 14, 2010 11:39 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] EMail recommendations

Hey All

I have spent the last couple of days looking all kinds of code for
EMailing (COD, STMP etc.) and third party products, (Blat etc. currently
looking at Total Access EMailer). Does anyone have any suggestions on
what route to go, to send EMails with attachments from an Access
application. I do not want to muck around on the user's machine
(basically stay away from their registry, no other installs other than
the Access application). Basically a no brainer for the user (enter your
user ID but no enter your STMP server address/ID etc.).  Orrrrrrrr.....I
am totally off base on this one and there is no easy simple solution.

Thanks


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com