<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2722.900" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=275205400-06022003>It's
an ActiveX dll, that when you register it on your system, and then add it to
your references, you can do this:</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=275205400-06022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=275205400-06022003>dim
Mail as MailSender</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=275205400-06022003>set
Mail=New MailSender</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=275205400-06022003>Mail.Host="MySMTPServer.MyDomain.com"</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=275205400-06022003>Mail.From="<A
href="mailto:You@YourDomain.com">You@YourDomain.com</A>"</SPAN></FONT></DIV>
<DIV><FONT><SPAN class=275205400-06022003></SPAN></FONT><FONT face=Arial><FONT
color=#0000ff><FONT size=2>M<SPAN class=275205400-06022003>ail.AddAddress = "<A
href="mailto:Me@MyDomain.com">Me@MyDomain.com</A>"</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=275205400-06022003>Mail.Subject="Testing"</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=275205400-06022003>Mail.Body="This is a
test."</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=275205400-06022003>Mail.IsHTML=False</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=275205400-06022003>Mail.Send</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=275205400-06022003></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=275205400-06022003>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).</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=275205400-06022003></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=275205400-06022003>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.)</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=275205400-06022003></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=275205400-06022003>Drew</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=275205400-06022003></SPAN></FONT></FONT></FONT><FONT face=Arial
color=#0000ff size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Software Design &
Solutions Pty Ltd. [mailto:SDSSoftware@Optusnet.com.au]<BR><B>Sent:</B>
Wednesday, February 05, 2003 4:35 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> Re: [AccessD] Outlook Crashes
Access - need it resolved in 2 hours.<BR><BR></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Hi drew. ASPEmail. How does that
work?</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Kath</FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=DWUTKA@marlow.com href="mailto:DWUTKA@marlow.com">Drew Wutka</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:'accessd@databaseadvisors.com'">'accessd@databaseadvisors.com'</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, February 06, 2003 4:14
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Outlook Crashes
Access - need it resolved in 2 hours.</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=892340817-05022003><FONT face=Arial color=#0000ff size=2>Go
ahead and send it to me. (<A
href="mailto:dwutka@marlow.com">dwutka@marlow.com</A>). 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.)</FONT></SPAN></DIV>
<DIV><SPAN class=892340817-05022003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=892340817-05022003><FONT face=Arial color=#0000ff
size=2>Drew</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Hollis,Virginia
[mailto:HollisVJ@pgdp.usec.com]<BR><B>Sent:</B> Wednesday, February 05,
2003 10:37 AM<BR><B>To:</B>
'accessd@databaseadvisors.com'<BR><B>Subject:</B> [AccessD] Outlook
Crashes Access - need it resolved in 2 hours.<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=460382916-05022003>I have to give
a training class in 2-1/2 hours on a new database. So I would
appreciate some help - quick!</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=460382916-05022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=460382916-05022003>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.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=460382916-05022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=460382916-05022003>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.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=460382916-05022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=460382916-05022003>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.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=460382916-05022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=460382916-05022003>Thanks!</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=460382916-05022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=460382916-05022003>Virginia</SPAN></FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>