Is it possible to copy a hyperlink from my excelsheet to my outlook agenda?
Everything works fine, but i am not able to get a working link in the body of the appointment.
This is what I have now...
Everything works fine, but i am not able to get a working link in the body of the appointment.
This is what I have now...
Code:
For r = 4 To 220
Link = Blad1.Cells(r, 125).Hyperlinks(1).Address
Link = Application.Substitute(Link, "../", "")
Link = Application.Substitute(Link, "/", "\")
Link = Application.Substitute(Link, " ", "%20")
Link = "file:C:///" & Link
If Len(Blad1.Cells(r, 21).Value) = 0 Then GoTo NextRow
sSubject = "[" & Blad1.Cells(r, 1).Value & "] " & Blad1.Cells(r, 11).Value & " [" & Blad1.Cells(r, 22).Value & "]"
sBody = Link
dStartTime = Blad1.Cells(r, 21).Value + TimeValue("10:00:00")
dEndTime = Blad1.Cells(r, 21).Value + TimeValue("11:00:00")
sLocation = Blad1.Cells(r, 14).Value
dReminder = 60
sName = Blad1.Cells(r, 1).Value
dCatagory = "Categorie Geel"