Bonjour Julien35000
Pour exporter une plage en fichier PDF
Sub TestExportAsFixedFormat()
' For information about the final parameter, see this page:
' http://msdn.microsoft.com/en-us/library/aa338206.aspx
Dim rng As Range
Set rng = Range("A1:E10")
' SetupRangeData rng
Dim fileName As String
' Change this file name to meet your own needs:
fileName = "C:\Temp\Export.pdf"
' Many of these properties are optional, and are included
' here only to demonstrate how you might use them. The
' Type parameter can be one of xlTypePDF and xlTypeXLS;
' the Quality parameter can be one of xlQualityStandard and
' xlQualityMinimum. Setting the OpenAfterPublish property
' to True fails if you do not have a default viewer
' installed and configured.
rng.ExportAsFixedFormat Type:=xlTypePDF, _
fileName:=fileName, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=True, _
From:=1, To:=1, OpenAfterPublish:=True
End Sub
Il ne te reste plus qu'à l'adapter pour joindre le fichier à ton mail
A+