Hi,
I have created an excel spreadsheet with corresponding VBA that allows a
user to enter in various bits of infomation click on a button which creates a
URL. I can insert this URL into an Outlook email and set the dist list,
subject etc... but I can't find a way to create the URL in the email with a
friendly name (such as "Click Here"). The following code allows me to create
a link with a friendly name on the excel sheet, but I need this in the email
!!!
With Worksheets(1)
.Hyperlinks.Add .Range("B13"), _
Address:=Sheets("Create Booking Event URL").Cells(13, 3), _
TextToDisplay:=DisplayText
End With
Thanks.