1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
|
Sub envoyerMailsAPartirDAccess()
'Set up DAO Objects:
Dim oDataBase As Object
Dim rst As Object
Dim iMsg As Object, iConf As Object, mailFrom As String, mailDestinataire As String, sendusing As Integer, smtpServer As String, smtpserverport As Integer
mailFrom = "monAdresse"
sendusing = 2
smtpServer = "monServeur"
smtpserverport = 25
Set oDataBase = OpenDatabase("C:\Documents and Settings\nicolas\Mes documents\access\contacts.mdb")
Set rst = oDataBase.OpenRecordset("selectMails")
With rst
.MoveFirst
' Loop through the Access records
Do While Not .EOF
mailDestinataire = ![Mail]
'**************** ENVOI DU MAIL
Set iMsg = CreateObject("CDO.Message")
Set iConf = CreateObject("CDO.Configuration")
With iMsg
Set .Configuration = iConf
.To = mailDestinataire
.from = mailFrom
.Subject = "Le titre du message"
'.HTMLBody = contenuHTML
.CreateMHTMLBody "C:\Documents and Settings\nicolas\Bureau\NEWSLETTER.html", cdoSuppressNone
.Fields("urn:schemas:mailheader:disposition-notification-to") = mailFrom
.Fields("urn:schemas:mailheader:return-receipt-to") = mailFrom
.Fields.Update
.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = sendusing
.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = smtpServer
.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = smtpserverport
.Configuration.Fields.Update
.Send
End With
.MoveNext
Loop
End With
End If
End Sub |
Partager