[AccessD] sending email in code - was: (no subject)

gregg steinbrenner greggs at msn.com
Thu Feb 20 16:27:00 CST 2003


I would!

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Seth Galitzer
Sent: Thursday, February 20, 2003 4: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




More information about the AccessD mailing list