Hello,

can somebody explain me how I can append a certain file on a e-mail via
vba-code

This is my current hyperlink:

With Worksheets(1)
..Hyperlinks.Add Anchor:=.Range("q42"), _
?subject=Info", _
ScreenTip:="Write us today", _
TextToDisplay:="mailto: "
End With

This is how I wan’t to make it:

1) I want to start the hyperlink with a command buttun

With Worksheets(1)
..Hyperlinks.Add Anchor:=.Range("q42"), _
?subject=Info", _
ScreenTip:="Write us today", _
TextToDisplay:="mailto: "
And here the Filepath…..
End With


--
Sylvian
------------------------------------------------------------------------
Sylvian's Profile: http://www.excelforum.com/member.php...o&userid=26730
View this thread: http://www.excelforum.com/showthread...hreadid=465489