Gustav Brock
Gustav at cactus.dk
Mon Jun 19 06:20:25 CDT 2006
Hi John That leaves you with CDO (cdosys.dll) which on the other hand is extremely powerful: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cdosys/html/ecdb51f4-5ba0-46d8-9c7c-7e4154a18f50.asp A real yummy for class nerds like you. Installed by default from Win 2000 and up. You will note the menu. Visit Developing Environment and Messaging. Unless the client has an Exchange server you can pass your mail to, you will have to specify an SMTP server to actually send your mail. That can be a small SendMail util installed on the workstation (but you didn't want that), the SMTP service of IIS - which may be installed and active on the workstation but most often is not, or on the server but with no access for the workstations. Or it can be the SMPT server in use by the client (which will be different for each client, thus your app will not know the name) or an external SMTP which will allow relaying and thus authentication (could be run by yourself on an old machine with, say, Mercury/32 server). But for the last two cases port 25 outbound must not be blocked on neither the workstation nor the corporate firewall which it quite often is. So, whatever CDO can do for you, you cannot define yourself out of potential trouble. What you can perform on a client's machine is really up to the network administrator. And if the client uses a locked down system with, say, Lotus Notes and no Internet access, your only chance may be MAPI. /gustav >>> jwcolby at colbyconsulting.com 19-06-2006 05:00:47 >>> I need: A piece of code, written in Access VBA, that will send an email message, complete with an attachment, regardless of where the Access Application is installed, regardless of what email client the application or computer user normally uses. It must NOT require installation of a DLL, knowledge of a specific email client, calls to methods of a specific email client, reference to a library (unless that library is ALWAYS available on EVERY Windows computer). I don't ask for much, just email. ;-) John W. Colby Colby Consulting www.ColbyConsulting.com