RSS Forums RSS
Please support our MS Access and FileMaker Pro advertiser: Programming Forums

Email direct from MS Access

Join Date: Feb 2007
Location: London
Posts: 114
Reputation: davidcairns is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 8
davidcairns davidcairns is offline Offline
Junior Poster

Solution Re: Email direct from MS Access

  #4  
Mar 28th, 2007
These days the CDO.Message object is more up to date. I had to switch over from CDONTS a while back.

This function was written for VBScript, you will have to set your SMTP server and obviously the BCC is optional


Public Sub emfSendEmail(byval pstrMailTo, _
byval pstrSubject, _
byval pstrMsg, _
byval pstrFromMail)

Dim objMsg, strSMTP, blnReturn

blnReturn = false

Const cdoSendUsingPort = 2

strSMTP = "someservername.domain.com"

Set objMsg = CreateObject("CDO.Message")

'Apply the settings to the message object
With objMsg

.From = pstrFromMail
.To = pstrMailTo
.BCC = "your email for testing"
.Subject = pstrSubject
.TextBody = pstrMsg

.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
'Name or IP of remote SMTP server
.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserver") = strSMTP
'Server port
'.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
.Configuration.Fields.Update

On Error Resume Next

.Send

If Err.Number = 0 Then
blnReturn = True
Else
response.write "(" & Hex(Err.Number) & ") " & Err.Description
End If

On Error Goto 0

End With

Set objMsg = Nothing

End Sub
Reply With Quote  
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 5:25 am.
Newsletter Archive - Sitemap - Privacy Statement - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC