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

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>


More information about the AccessD mailing list