[AccessD] EMail recommendations

Hi Tony

Yes.
Now, you don't tell what your application is and what mail volume to expect, but one option we have used was to provide the name of one of our SMTP servers (users were sending mail to us only anyway) as the default (or only) option, and then use authentication which could be fixed in code when your server is used. 

You don't have an SMTP server? Well, you probably have, as all versions of Windows Server features an SMTP service which is piece of cake to "wake up" and configure. Resource consumption of this is very low and can - if you prefer a separate box - run on some outdated but reliable hardware. NT4 runs in 64 MB ram.

Jim is correct that CDO replaced CDONTS of NT4 - you probably don't have such users. If you have such or Win9x(!) users you should/must provide your own control or DLL.

As for the protocols, the only one in use for sending mail is SMTP which happens to be the simplest, in fact S stands for Simple. POP3 and IMAP are for retrieving mail.

/gustav


>>> iggy at nanaimo.ark.com 15-02-2010 17:47 >>>
Hey Gustav
I have to admit I am a bit of a ditz when it comes to understanding all 
about Email protocols. In your example would the user (me included) need 
to know their STMP server ID?


Gustav Brock wrote:

>Hi Tony
>
>If you don't want to install anything, I can recommend using the native Windows CDO component which is installed by default on any newer Windows.
>Code is a bit long-winded but very flexible. Also, it can mail to either an in-house Exchange server directly or to a normal SMTP server.
>Here's an example that via SMTP emails one attachment - more can be added quite easily:
>
><code>
>  Dim msg As New CDO.Message
>
>  With msg
>    With .Fields
>      ' Custom X-Mailer info.
>      .Item(cdoXMailer) = "My Mailer V2.0"
>      .Update
>    End With
>    With .Configuration.Fields
>      .Item(cdoSMTPAuthenticate) = cdoAnonymous   'cdoBasic
>      ' .Item(cdoSendUserName) = "myusername"
>      ' .Item(cdoSendPassword) = "mypassword"
>      .Item(cdoSendUsingMethod) = cdoSendUsingPort
>      .Item(cdoSMTPServer) = "smtp.yourisp.com"
>      .Item(cdoSMTPConnectionTimeout) = 10
>      .Item(cdoSMTPServerPort) = 25
>      .Update
>    End With
>    .Organization = "myorganisation.org"
>    .To = "receiver at example.com"
>    .Subject = "Example to Example with attachment"
>    .TextBody = "Here you are!"
>    .From = "me at mydomain.com"
>    .AddAttachment ("c:\temp\report.pdf")
>    .Send
>  End With
>        
>  Set msg = Nothing
></code>
>
>And the CDO component is very fast - at zero cost.
>
>/gustav
>
>
>  
>
>>>>iggy at nanaimo.ark.com 14-02-2010 17:39 >>>
>>>>        
>>>>
>Hey All
>
>I have spent the last couple of days looking all kinds of code for 
>EMailing (COD, STMP etc.) and third party products, (Blat etc. currently 
>looking at Total Access EMailer). Does anyone have any suggestions on 
>what route to go, to send EMails with attachments from an Access 
>application. I do not want to muck around on the user's machine 
>(basically stay away from their registry, no other installs other than 
>the Access application). Basically a no brainer for the user (enter your 
>user ID but no enter your STMP server address/ID etc.).  Orrrrrrrr.....I 
>am totally off base on this one and there is no easy simple solution.
>
>Thanks