ActiveWorkbook.Save
Application.DisplayAlerts = False
Application.Visible = False
Dim Maille As String
Dim Sujet As String
Maille = "claudejulien@hotmail.com"
Sujet = "Backup SoftNote 2005 / " & Now
Set OL = CreateObject("Outlook.Application")
Set MyItem = OL.CreateItem(olMailItem)
With MyItem
.To = Maille
.Subject = Sujet
.Categories = "Banking-Info"
.OriginatorDeliveryReportRequested = False
.ReadReceiptRequested = False
.Attachments.Add "F:\Documents and Settings\Clqude\Mes documents\Base\EXCEL.FDB"
.Send
End With
MsgBox "Votre classeur a bien été envoyé", vbInformation, ""
ActiveWorkbook.Save
ActiveWorkbook.Close
Application.Quit
Application.Visible = True
ActiveWorkbook.Close
Application.DisplayAlerts = True
Sub Envoi_Image()
Export_Image_de_Plage
Envoi_mail
End Sub
Sub Export_Image_de_Plage()
Dim ndf As String
Dim Source As Range, Gr As Object
ndf = ActiveWorkbook.Path & "\Confirmation de " & [A1] & ".gif"
Set Source = Sheets("Feuil1").Range("A1:D30") 'Ici tu modifies la plage que tu veux enregistrer et envoyer.
Source.CopyPicture xlScreen, xlPicture
Set Gr = Sheets("Feuil1").ChartObjects.Add(0, 0, Source.Width, _
Source.Height)
Gr.Chart.Paste
Gr.Chart.Export ndf, "GIF"
Gr.Delete
Set Gr = Nothing
Set Source = Nothing
End Sub
Sub Envoi_mail()
Dim Ol As New Outlook.Application
Dim Olmail As MailItem
Dim CurrFile As String
Set Ol = CreateObject("Outlook.Application")
Ol.Session.Logon
Set Olmail = Ol.CreateItem(olMailItem)
On Error Resume Next
With Olmail
.To = [A1] 'Destinataire
.Subject = [A2] 'Sujet
.Body = [A3] 'Corps (message)
.Attachments.Add ActiveWorkbook.Path & "\Message de " & [A1] & ".gif"
.Send 'Ou Display pour afficher la fenêtre Outlook
End With
End Sub
Sub EnvoiFeuil()
Destinataire = Sheets(2).Range("A1") 'Ici je récupère l'adresse par exemple dans la feuille2
ActiveSheet.Copy
With ActiveWorkbook
.SendMail Recipients:=Destinataire
Application.DisplayAlerts = False
.Close
Application.DisplayAlerts = True
End With
End Sub