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
|
Public Function EnvoyerMail(ByVal SendFrom As String, _
ByVal SendTo As String, _
ByVal Subject As String, _
ByVal PlainTextBody As String, _
Optional FullPathFileName As String)
Dim Message As New CDO.Message
Dim config As CDO.Configuration
' Configuration du mail
Set config = New CDO.Configuration
With config.Fields
.Item(cdoSendUsingMethod) = cdoSendUsingPort
.Item(cdoSMTPServer) = "nomDeMonServeurExchagneIci"
.Item(cdoSendUserName) = "NomUtilisateur"
.Item(cdoSendPassword) = "MotDePasse"
.Item(cdoSMTPServerPort) = 25
.Update
End With
' Envoi du message
Set Message = New CDO.Message
Set Message.Configuration = config
Message.From = SendFrom
Message.To = SendTo
Message.Subject = Subject
Message.TextBody = PlainTextBody
Message.AddAttachment ("C:\cheminfichier.txt") ' exemple de fichier à joindre
Message.Send
Set Message = Nothing
End Function |
Partager