John W. Colby
jcolby at colbyconsulting.com
Thu Feb 20 16:39:01 CST 2003
Ho yea, I do, I do (waving hand vigorously in the air) John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com]On Behalf Of Seth Galitzer Sent: Thursday, February 20, 2003 5:14 PM To: accessd Subject: RE: [AccessD] sending email in code - was: (no subject) Randy, If you're interested, I've got a class module which will send the email for you, bypassing Outlook altogether. It was given to me by a friend, and I edited it so it would be more encapsulated. I use it for sending plaintext, but it is supposed to be able to handle attachments as well. It basically encapsulates the SMTP protocol entirely, including wrapping the appropriate winsock API calls. I use it to "phone home" with application errors for one of my apps that runs unattended. I can post it on my website if you or anyone else would like to see it. Seth On Thu, 2003-02-20 at 14:50, founder at restechonline.com wrote: > Thanks Andy... > > One more question, How can I output a recordset to an email??? > > aaaaggghh!!!! > > > > Andy Lacey <andy at minstersystems.co.uk> said: > > > Hi Randy > > The line > > > > Set obj = GetObject(, "Outlook.Application") > > > > will error if it isn't, and you can trap that. > > HTH > > > > Andy Lacey > > http://www.minstersystems.co.uk > > > > > > > > > -----Original Message----- > > > From: accessd-admin at databaseadvisors.com > > > [mailto:accessd-admin at databaseadvisors.com] On Behalf Of > > > founder at restechonline.com > > > Sent: 20 February 2003 18:43 > > > To: accessd at databaseadvisors.com > > > Subject: [AccessD] (no subject) > > > > > > > > > Group, > > > > > > I am having on of those days... I want to open MS Outlook > > > from an A2k module and review the email before I send it. > > > > > > How can I check to see if MS Outlook is already open? > > > > > > Thanks, > > > Randy > > > > > > -- > > > Thank you, > > > Randy Sigmond > > > Restech Online - Founder > > > Ph: 248.568.0053 > > > www.restechonline.com > > > Where People Make The Difference. > > > -- Seth Galitzer sgsax at ksu.edu Computing Specialist http://puma.agron.ksu.edu/~sgsax Dept. of Plant Pathology Kansas State University _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com -------------- next part -------------- A non-text attachment was scrubbed... Name: winmail.dat Type: application/ms-tnef Size: 2972 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030220/25c89f22/attachment-0002.bin>