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
    NoCanDo:
    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
    Philipp

  • Re: Open Outlook Mail after click on button


    Thank you very much, lasw10!!!


    Can I manipulate the body of the email as well?


    Cheers,


    Philipp

  • 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,


    Philipp

Participate now!

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