One thought on “Email Hyperlink that includes attachment

  1. Katie

    Hi

    I think the best way to complete this would be to use a small bit of VBA code. And then add a button to the worksheet to send the active workbook as an attachment.

    So add this to your VBA:

    Sub EmailMe()

    ActiveWorkbook.SendMail _
    Recipients:="RECIPIENT EMAIL ADDRESS HERE", _
    Subject:="SUBJECT TITLE OF EMAIL HERE"

    End Sub

    Then add a button to your worksheet, and then go into the VBA code for it and the following so that when you click it it will run the code.

    Private Sub CommandButton1_Click()
    Call EmailMe
    End Sub

    I’ve tested this in 2007 and 2010, but it should also work in 2003.

    Hope it helps you!

Leave a Reply

Your email address will not be published. Required fields are marked *