Function SansDoublons(pMailAddr As String)
Dim oDico As Object
Dim vAdr As Variant
Dim vKey As Variant
Set oDico = CreateObject("Scripting.Dictionary")
For Each vAdr In Split(pMailAddr, ";")
oDico(vAdr) = "" 'On stocke la clé et sa valeur ("") dans le dico.
Next vAdr
SansDoublons = "" 'Init. résultat
For Each vKey In oDico.keys 'On parcourt les clefs du dictionnaire
If SansDoublons <> "" Then SansDoublons = SansDoublons & ";" 'Séparateur
SansDoublons = SansDoublons & vKey 'Ajout clé au résultat
Next vKey
End Function