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
|
Sub EnvoiMail(mto As String, mcc As String, sujet As String, fichierjoint As String, message As String)
On Error GoTo erreur
Dim s() As String, i As Long
Dim MonAppli As Outlook.application
Dim MonMail As Outlook.MailItem
Dim MonFichierJoint As Outlook.Attachments
Set MonAppli = Outlook.application
Set MonMail = MonAppli.CreateItem(olMailItem)
Set MonFichierJoint = MonMail.Attachments
s = Split(fichierjoint, ";")
For i = 0 To UBound(s)
MonFichierJoint.Add s(i), olByValue, 1, ""
Next i
MonMail.BodyFormat = olFormatHTML
MonMail.Subject = sujet
MonMail.Body = message
MonMail.To = mto
MonMail.cc = mcc
MonMail.Display
MonMail.Send
Set MonAppli = Nothing
Set MonMail = Nothing
Set MonFichierJoint = Nothing
Exit Sub
erreur:
End Sub |
Partager