1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| ActiveSheet.Range("A1:n40").Select
ActiveWorkbook.EnvelopeVisible = True
With ActiveSheet.MailEnvelope
.Introduction = "Bonjour ," & vbCrLf & " " & vbCrLf & "Merci de bien vouloir prendre en considération la demande ci dessous." & vbCrLf & " " & vbCrLf & "Cordialement"
.Item.To = "xxxxxx@xxx.xxx"
.Item.Subject = Range("a8") & " / " & Range("c15") & " / " & Range("c13")
.Item.send
Range("c13,c15,e22,f24,f26,i24,i26,c30").Value = ""
Unload Me
UserForm_Quitter.Show
End With
End Sub |
Partager