append file on e-mail
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 |
All times are GMT +1. The time now is 03:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com