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