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 55 56 57 58 59 60 61 62 63 64 65 66 67
| Sub EmailViaExcel()
Dim OL As Outlook.Application
If UCase(Application) = "OUTLOOK" Then
Set OL = Application
Else
Set OL = CreateObject("outlook.application")
End If
Set oMail = OL.CreateItem(olMailItem) '0
Const olFormatHTML = 2
With oMail
.To = Adresse
.BodyFormat = olFormatHTML
.Subject = "HMTL BODY du " & Date
' debut du message html
Const SAUTLIGNE = "<br/>"
.HTMLBody = "<body>"
img1 = "1-4.jpg"
img2 = "2-4.jpg"
img3 = "3-4.jpg"
img4 = "4-4.jpg"
On Error Resume Next
.Attachments.Add ThisWorkbook.path & "\" & "1-4.jpg", olByValue, 0
.Attachments.Add ThisWorkbook.path & "\" & "2-4.jpg", olByValue, 0
.Attachments.Add ThisWorkbook.path & "\" & "3-4.jpg", olByValue, 0
.Attachments.Add ThisWorkbook.path & "\" & "4-4.jpg", olByValue, 0
On Error GoTo 0
'Ecrit bonjour en gras, calibri, taille 40
.HTMLBody = .HTMLBody & "<font face=""calibri"" size =""40"" color=""black""> hello <b>Bonjour ! " & prenom & " " & Nom & "</b></font>"
'Saute deux lignes
.HTMLBody = .HTMLBody & SAUTLIGNE & SAUTLIGNE
'Ecrit le reste de l'entete
.HTMLBody = .HTMLBody & SAUTLIGNE & SAUTLIGNE
.HTMLBody = .HTMLBody & "<div align='center'><table>"
.HTMLBody = .HTMLBody & "<tr>"
.HTMLBody = .HTMLBody & "<td valign='middle'><b>test : <input type='text'>Ligne 1 - cols 1</input></b></td>"
.HTMLBody = .HTMLBody & "<td valign='middle'><b><img src='" & img1 & "'>"
.HTMLBody = .HTMLBody & "Ligne 1 - cols 2</b></td>"
.HTMLBody = .HTMLBody & "<td valign='middle'><b><img src='" & img2 & "'>"
.HTMLBody = .HTMLBody & "Ligne 1 - cols 3</b></td>"
.HTMLBody = .HTMLBody & "</tr>"
.HTMLBody = .HTMLBody & "<tr>"
.HTMLBody = .HTMLBody & "<td valign='middle'><b><img src='" & img3 & "'>"
.HTMLBody = .HTMLBody & "Ligne 2 - cols 1</b></td>"
.HTMLBody = .HTMLBody & "<td valign='middle'><b><img src='" & img4 & "'>"
.HTMLBody = .HTMLBody & "Ligne 2 - cols 2</b></td>"
.HTMLBody = .HTMLBody & "<td valign='middle'><b>Ligne 2 - cols 3</b></td>"
.HTMLBody = .HTMLBody & "</tr>"
.HTMLBody = .HTMLBody & "</table></div>"
.HTMLBody = .HTMLBody & "</body>"
.Display
DoEvents
.Send
End With
End Sub |
Partager