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

MartyConnelly martyconnelly at shaw.ca
Fri Feb 21 13:15:00 CST 2003


Here is a vbs script to send lotus notes email with attachments

http://cwashington.netreach.net/depo/view.asp?Index=761&ScriptType=vbscript
I have seen others on www.slipstick.com


John Frederick wrote:

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





More information about the AccessD mailing list