[AccessD] Outlook Crashes Access - need it resolved in 2 hour s.

It's an ActiveX dll, that when you register it on your system, and then add
it to your references, you can do this:
 
dim Mail as MailSender
set Mail=New MailSender
Mail.Host="MySMTPServer.MyDomain.com"
Mail.From=" You at YourDomain.com <mailto:You at YourDomain.com> "
Mail.AddAddress = " Me at MyDomain.com <mailto:Me at MyDomain.com> "
Mail.Subject="Testing"
Mail.Body="This is a test."
Mail.IsHTML=False
Mail.Send
 
Whalla.  Of course this is all in it's documentation.  There is a free
component, which does what I have above (it allows for multiple To and CC's,
and also for adding file attachments if you want).
 
The one you have to pay for allows you to distribute it, and has all sorts
of other fun stuff (haven't bought it, but the documentation mentions a mail
'service', so that you can 'queue' your emails.)
 
Drew
 

-----Original Message-----
From: Software Design & Solutions Pty Ltd.
[mailto:SDSSoftware at Optusnet.com.au]
Sent: Wednesday, February 05, 2003 4:35 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Outlook Crashes Access - need it resolved in 2 hours.


Hi drew. ASPEmail. How does that work?
Kath

----- Original Message ----- 
From: Drew Wutka <mailto:DWUTKA at marlow.com>  
To: 'accessd at databaseadvisors.com' <mailto:'accessd at databaseadvisors.com'>  
Sent: Thursday, February 06, 2003 4:14 AM
Subject: RE: [AccessD] Outlook Crashes Access - need it resolved in 2 hours.

Go ahead and send it to me.  ( dwutka at marlow.com <mailto:dwutka at marlow.com>
).  I personally recommend using ASPEmail.  Even though it was 'built' for
sending mail through ASP, it is just a .dll, so you can use it anywhere you
can create an object. (VB, VBA, VBScript, etc.)
 
Drew

-----Original Message-----
From: Hollis,Virginia [mailto:HollisVJ at pgdp.usec.com]
Sent: Wednesday, February 05, 2003 10:37 AM
To: 'accessd at databaseadvisors.com'
Subject: [AccessD] Outlook Crashes Access - need it resolved in 2 hours.


I have to give a training class in 2-1/2 hours on a new database. So I would
appreciate some help - quick!
 
The form is set up with a button that will send out a pre-formatted email
containing the fields from the request. For example, a new request is
entered, the user clicks the button that opens outlook & sends Engineering
the request with their name, request title, & description of request.
 
All of sudden when I was doing some checking today, the database crashes
when trying to send the emails. It will create the email, but if I close the
email, Access crashes.
 
The code is a little long, so if there is someone that would help me with
this, I could send it to them, it is A2K.
 
Thanks!
 
Virginia

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030205/3d4f8220/attachment-0002.html>