Sub Envoi_Mail()
Dim olApp As Outlook.Application
Dim olMail As MailItem
Dim StrBody As String
Set olApp = CreateObject("Outlook.Application")
Set olMail = olApp.CreateItem(olMailItem)
StrBody = "Bonjour Monsieur," & vbCrLf & vbCrLf & "bien dormi cette nuit ?"
With olMail
.To = ""
.CC = ""
.Subject = "Message rappel"
.Body = StrBody
.Display
End With
Set olMail = Nothing
Set olApp = Nothing
End Sub
Sub Envoi_Mail()
Dim olApp As Outlook.Application
Dim olMail As MailItem
Dim StrBody As String
Set olApp = CreateObject("Outlook.Application")
Set olMail = olApp.CreateItem(olMailItem)
StrBody = "<HTML><Body><p><Span style='font-family:Tahoma;font-size:10pt'>Bonjour Mesdames et Messieurs.</p>" _
& "<p>Soyez les bienvenus à cette réunion concernant le projet</span></p>" _
& "<p><Span style='color:blue;font-family:Tahoma;font-size:16pt'><b><i><center>NEW STRATEGY</center></i></b></span></p>" _
& "<p><center><img src='C:\meeting.gif'></center></p></Body><HTML>"
With olMail
.To = ""
.BCC = ""
.Subject = "Projet NEW STRATEGY"
.HTMLBody = StrBody
.Display
End With
Set olMail = Nothing
Set olApp = Nothing
End Sub
Bonjour
Tous est dans le titre
Crdl
Bonjour serdar75, ralph45
Voici deux façons de faire, ne pas oublier de cocher la référence Microsoft Outlook Object Library.
Code:Sub Envoi_Mail() Dim olApp As Outlook.Application Dim olMail As MailItem Dim StrBody As String Set olApp = CreateObject("Outlook.Application") Set olMail = olApp.CreateItem(olMailItem) StrBody = "Bonjour Monsieur," & vbCrLf & vbCrLf & "bien dormi cette nuit ?" With olMail .To = "" .CC = "" .Subject = "Message rappel" .Body = StrBody .Display End With Set olMail = Nothing Set olApp = Nothing End Sub
Code:Sub Envoi_Mail() Dim olApp As Outlook.Application Dim olMail As MailItem Dim StrBody As String Set olApp = CreateObject("Outlook.Application") Set olMail = olApp.CreateItem(olMailItem) StrBody = "<HTML><Body><p><Span style='font-family:Tahoma;font-size:10pt'>Bonjour Mesdames et Messieurs.</p>" _ & "<p>Soyez les bienvenus à cette réunion concernant le projet</span></p>" _ & "<p><Span style='color:blue;font-family:Tahoma;font-size:16pt'><b><i><center>NEW STRATEGY</center></i></b></span></p>" _ & "<p><center><img src='C\meeting.gif'></center></p></Body><HTML>" With olMail .To = "" .BCC = "" .Subject = "Projet NEW STRATEGY" .HTMLBody = StrBody .Display End With Set olMail = Nothing Set olApp = Nothing End Sub
Edit: Bonjour Modeste geedee
A+
Bonjour Lone-Wolf et raph45
J'ai un message d'erreur