Option Explicit Dim varSMTPRelay 'Adresse du serveur de messagerie / relais smtp Dim varDestEmail, varSujetMail, varMessageMail, varSenderMail varSMTPRelay = "AdresseServeurSMTP" varDestEmail = "AdressemailDestinataire@domaine.com" varSenderMail = "AdressemailEnvoyeur@domaine.com" varSujetMail = "Password Will Expire" varMessageMail = "Votre mot de passe va expirer dans " & "x" & " jours." Call EnvoyerEmail(varSMTPRelay, varDestEmail, varSenderMail, varSujetMail, varMessageMail) Public Function EnvoyerEmail(varSMTPRelay, varDestEmail, varSenderMail, varSujetMail, varMessageMail) Dim objMessage Set objMessage = CreateObject("CDO.Message") objMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 objMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = varSMTPRelay objMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25 objMessage.Configuration.Fields.Update objMessage.Subject = varSujetMail objMessage.Sender = varSenderMail objMessage.To = varDestEmail objMessage.TextBody = varMessageMail objMessage.Send Set objMessage = Nothing End Function