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

Yes, please post :). BTW anyone here happen to be stuck with Lotus Notes
like me, and have any code for sending via that? Thanks

Lyle Hannum



                                                                                                      
                    Seth Galitzer                                                                     
                    <sgsax at ksu.edu>                To:     accessd <accessd at databaseadvisors.com>     
                    Sent by:                       cc:                                                
                    accessd-admin at databasead       Subject:     RE: [AccessD] sending email in code - 
                    visors.com                      was: (no subject)                                 
                                                                                                      
                                                                                                      
                    02/20/03 05:14 PM                                                                 
                    Please respond to                                                                 
                    accessd                                                                           
                                                                                                      
                                                                                                      




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