John Frederick
j.frederick at att.net
Fri Feb 21 12:07:00 CST 2003
I'm a customer too. I have an unsolved problem of generating email messages with document attachments on client machines that have Office 2000 but use Lotus Notes for email. I got some code that tied into the MAPI interface from one of the participants in this forum awhile back, but I could never get the attachment feature to work. > -----Original Message----- > From: accessd-admin at databaseadvisors.com > [mailto:accessd-admin at databaseadvisors.com] > Sent: Thursday, February 20, 2003 5:39 PM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] sending email in code - was: (no subject) > > 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: 3300 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030221/17c270e8/attachment-0002.bin>