[AccessD] EMail recommendations

Max (MGA) max.wanadoo at gmail.com
Mon Feb 15 12:51:17 CST 2010


Tony,

Just a suggestion.  Go to www.support.it-mate.co.uk
Do a search  for smtp finder.

If you install it, you can enter your client's email  address  in there  and
find their address.
Ton of other stuff on there as well.

Max
Ps. No recommendations  though, just for info.



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
Sent: 15 February 2010 16:48
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] EMail recommendations

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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list