Stuart McLachlan
stuart at lexacorp.com.pg
Wed Feb 5 19:39:00 CST 2003
If you are feeding to an SMTP server it may also be worth looking at BLAT. Its freeware. http://www.interlog.com/~tcharron/blat.html Primarily designed as a CLI mailer, there is also a DLL version avaiable at http://www.geocities.com/toby_korn/blat/ You don't need to worry about registry or references, just drop the DLL somewhere in your path and use a Declare Function SendBlat Lib "blat.dll" Alias "Send" (ByVal sCmd As String) As Integer There's also an example of an Access Class module which uses Blat.exe at http://www.j-enterprises.com/MSAccess_Blat.htm it would be trivial to modify this to use the DLL instead so as to get better feedback on error codes. (I may get around to it one day myself) On 5 Feb 2003 at 19:03, Drew Wutka wrote: > 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 > > -- Stuart McLachlan Lexacorp Ltd Application Development, IT Consultancy http://www.lexacorp.com.pg