Dim MonOutlook As Outlook.Application
Dim MonMessage As MailItem
Set MonOutlook = New Outlook.Application
Set MonMessage = MonOutlook.CreateItem(olMailItem)
' Préparation du message :
MonMessage.to = "moceks@hager.fr"
' Récupération de la chaîne d'E-Mails Access :
MonMessage.bcc = ListeComplete
MonMessage.Subject = "Promotions pour les vacances"
Corps = "Bonjour,"
Corps = Corps & Chr(13) & Chr(10)
Corps = Corps & "Profitez de nos dernières actions pour la Tunisie"
MonMessage.body = Corps
' Affichage :
MonMessage.Display
'Attente
Dim Debut As Long, Fin As Long
Debut = Timer
Fin = Debut + 1 '1 seconde
Do Until Timer >= Fin
DoEvents
Loop
'envoie ctrl-enter
SendKeys "^{enter}"
'vider controle
Set MonOutlook = Nothing
Set MonMessage = Nothing