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

John...

I send Lotus Notes email (in Access 97) with attachment using the code (with
tweaks) from this site
http://cwashington.netreach.net/depo/view.asp?Index=761&ScriptType=vbscript

This routine (SendNotesMail) is referenced several places on the web -- I
had to look at a few before I found the version that worked for me.

BarbRyan

----- Original Message -----
From: John Frederick <j.frederick at att.net>
To: <accessd at databaseadvisors.com>
Sent: Friday, February 21, 2003 1:06 PM
Subject: RE: [AccessD] sending email in code - was: (no subject)


> 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
>