Email (outlook) recipients attaching specific file name.

Please find attached a sample file which I'm wondering if it's possible to run a macro from to email the specified recipients and attach the filename. It wouldn't matter that different files were emailed to the same recipient separately.

The files that this sample refers to are all saved in the same directory.

Your help would be appreciated.

Yes, it is possible. Here is some code to get you started. This sends the active sheet as a pdf using Outlook.

Sub SendWorkSheetToPDF()
Dim Wb As Workbook
Dim FileName As String
Dim OutlookApp As Object
Dim OutlookMail As Object
On Error Resume Next
Set Wb = Application.ActiveWorkbook
FileName = "full path of file goes here"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=FileName
Set OutlookApp = CreateObject("Outlook.Application")
Set OutlookMail = OutlookApp.CreateItem(0)
With OutlookMail
    .Subject = "subject"
    .To = "someone@somesite.com"
    .Attachments.Add FileName
    .Display
End With
Kill FileName
Set OutlookMail = Nothing
Set OutlookApp = Nothing
End Sub