emaildest="toto@toto.com" emailsubject = "Fichier Excel du : " & Format(Now, "dd/mm/yy") emailmsg = InputBox("Indiquer un léger message pour votre mail", "LCR Online") Dim ObjOutl As Object Dim objSession As Object On Error Resume Next Set ObjOutl = CreateObject("Outlook.Application") Set objSession = ObjOutl.GetNamespace("MAPI") Set ObjMessage = ObjOutl.CreateItem(0) objSession.Logon With ObjMessage .To = emaildest .CC = "" .Subject = emailsubject .Body = emailmsg .Attachments.Add App.Path & "\Excel.xls" .Send End With Set ObjMessage = Nothing objSession.Logoff Set objSession = Nothing Set ObjOutl = Nothing