Open Outlook Mail after click on button

  • Dear Experts,

    I fear it is a silly question but even after I explored this and other forum I could not find an answer to my small problem:

    I have a userform (say userform1) and there is one Image (say Image1) included. Now the user should be able to click on the image1 and then an outlook email opens. I managed it but not completely. So far, an email opens and the receipient is all right but I am not able to set the subject line!

    Could pleaaaaaasssse someone help me with that?
    Here is my code so far, maybe it could be adjusted?

    Private Sub Image1_Click()
    Link = "mailto:[email protected]"
    On Error GoTo NoCanDo
    ActiveWorkbook.FollowHyperlink Address:=Link, NewWindow:=True

    Exit Sub
    MsgBox "Tschuldige, Cannot open " & Link
    End Sub

    I only want to be able to manipulate the subject line and maybe, not that important, the body as well.

    Thank you

  • Re: Open Outlook Mail after click on button

    Thank you very much, lasw10!!!

    Can I manipulate the body of the email as well?



  • Re: Open Outlook Mail after click on button

    Hi again,

    due to your previous tip I was able to solve the body manipulation on my own. simply write

    Link = "mailto:[email protected]?subject=Help&body=thanks for your help"

    than it works...

    Thank you anyway

  • Re: Open Outlook Mail after click on button

    Sorry Experts,

    I have again a question:

    I would like to edit the body text which will be displayed in the mail.
    Is it possible to edit fontsize and to make a break?

    Thank you,


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!