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 52 53 54
|
Public Sub SendOLMail( _
ByVal strEmail As String, _
ByVal strObj As String, _
ByVal strMsg As String, _
ByVal blnEdit As Boolean, _
Optional ByVal avarFichiers As Variant)
Dim ol As Outlook.Application
Dim mi As Outlook.MailItem
strEmail = "xxx@gmail.com"
strObj = "Test"
strMsg = "Bonjour, hello"
blnEdit = True
avarFichiers = "fichier1.PDF"
Dim varPJ As Variant
' Créer une instance d'Outlook
On Error GoTo OLMailErr
Set ol = New Outlook.Application
' Créer un objet Email
Set mi = ol.CreateItem(olMailItem)
' Paraméter le message
With mi
.To = strEmail
.Subject = strObj
.Body = strMsg
' Joindre les pièces, s'il y en a
Attachments.Add "C:/Etiquette.docx"
If blnEdit Then
.Display
Else
.send
End If
End With
Set mi = Nothing
Set ol = Nothing
Exit Sub
OLMailErr:
MsgBox "Erreur : " & err.Number & vbCrLf & err.Description
Exit Sub
End Sub |
Partager