Jim Dettman
jimdettman at earthlink.net
Mon Jun 19 06:05:59 CDT 2006
John, The way I do it and have seen most others is that I *require* an SMTP server to send notifications. If the client doesn't have one, then they don't get e-mail notifications. I send directly to an SMTP server because I never can be sure what e-mail client is installed. I've worked in environments with Lotus Notes, Outlook, Thunderbird, etc; just too many different clients to worry about. SMTP is a standard, which will always be the same for basic message sending. To do that, I've always used vbSendMail. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Sunday, June 18, 2006 8:08 PM To: AccessD Subject: [AccessD] email from outlook I know this has gone around many times and I hang my head in shame to even ask again, but is there a "no brainer, no nonsense" way to send email from VBA code, that will just work, without needing to have any specific email client installed. In the past I have always used MS Outlook, simply because that is installed at all of my clients, however I am working on my framework book and need something that anyone anywhere can "just use". It should have the typical From/To/Subject/message and also be able to attach files to it. TIA, John W. Colby Colby Consulting -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com