Hi All

I've just been going through your replies, I can see how they are supposed to work . I've tried your code Izandol as it was the easiest to implement. But it still will not add the attachment???

I noticed in your code Sean an item:

'   Copies sheet1 and Calls function Create_PDF to create a pdf copy and place in e-mail
'   Uses early binding
'   Requires a reference to the Outlook 12.0 Object Library
    Dim OutlookApp As Outlook.Application
    Dim MItem As Object
    Dim Recipient As String, Subj As String
    Dim Msg As String, Fname As String
    Dim EmailAddr As String
    Dim NewFilename As String
            
    Application.ScreenUpdating = False
Could this be what is missing from my code? Or could it be something in the settings? I'm running on widows 8.1 and office 2013

Regards

Paul