Sub EnvoiMail()
'
'necessite d'activer la reference Microsoft Outlook xx.x Object Library
'dans l'editeur de macros:
'menu outils
'references
'cocher la ligne :Microsoft Outlook xx.x Object Library
'cliquer sur 'ok' pour valider
'
Dim OutApp As Outlook.Application
Dim OutMess As Outlook.MailItem
Dim myLst As Range, Valeur As Range
Set OutApp = CreateObject('outlook.application')
Set OutMess = OutApp.createitem(olmailitem)
Set myLst = Sheets('myadress').Range('A1:A2')
For Each Valeur In myLst
OutMess.Recipients.Add Valeur
Next Valeur
OutMess.Subject = 'Inscrire ici le sujet de l'envoie'
OutMess.Attachments.Add ActiveWorkbook.FullName
OutMess.send
End Sub