Bonjour,
peut-être pas une solution élégante mais essaie ceci
remplace
Dim cel1 As Range
Set cel1 = Range("A1")
Dim email As String
Dim NomOrdinateur As String
Dim NomFichier As String
Dim NomFichierComplet As String
NomOrdinateur = Application.UserName
Set iMsg = CreateObject("CDO.Message")
Set iConf = CreateObject("CDO.Configuration")
Set Flds = iConf.Fields
For i = 1 To 3
par
Dim cel1 As Range
Set cel1 = Range("A1")
Dim email As String
Dim NomOrdinateur As String
Dim NomFichier As String
Dim NomFichierComplet As String
For i = 1 To 3
NomOrdinateur = Application.UserName
Set iMsg = CreateObject("CDO.Message")
Set iConf = CreateObject("CDO.Configuration")
Set Flds = iConf.Fields