Yet Another Weary Mail Note (YAWMN) 2

[groleau]

There sure is a lot of stuff in here about e-mailing from
Access VBA. They seem to divide into four categories:

1. Those that require Microsoft Outlook
2. Those that require Lotus Notes
3. Those that require GroupWise
4. Those that will use any e-mail client, provided the
client is running and logged in

We have groupwise, and every time there's an upgrade,
we have to tweak the code. Also every time the password
changes. So does anyone know of a VBA equivalent to the
dot-net System.Net.Mail ? That thing works even if
there's no e-mail client and no account available.
All it needs is the IP address of an SMTP server that
will accept port 25 connections from the machine
the VBA is running on.

(Or a hostname and a DNS server that knows the name)

Thanks,

--
Wes Groleau

http://www.Parkview.com/

 

[PHV]

Have a look at CDO.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[AlexCuse]

You can use CDO to send emails through SMTP from access. This is probably your best bet in terms of not needing to change your code (unless of course you change server IP address/DNS). It also of course doesn't require a client.

I can track down a script if you need it.

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[groleau]

THANKS.

I'll look up CDO and I can probably figure out the rest. If not, I'll be back.

--
Wes Groleau

http://www.Parkview.com/