How to open an outlook email template from a link?

[dawn10]

Hi all,

I have the following macro to open an email template and edit the recepients.
So far i could only open the email template from a .oft file stored on my local drive. Could you advise how to open it directly from a web link?

I tried to replace the path (highlighted in Red) to a link but it did not work out. Appreciate your help!!

Sub emailTmp()
On Error Resume Next
Dim template
Dim newItem 'As Mail
Dim Outlook 'As Outlook.Application
Dim aTo
Dim inputSheet1
Dim myRecipient

Set inputSheet1 = Worksheets("Sheet1")
Set inputSheet2 = Worksheets("Sheet2")
aTo = inputSheet2.Cells(2, 1)
'Debug.Print aTo

Set template = inputSheet1.Cells(5, 2)
'Debug.Print template

Set Outlook = CreateObject("Outlook.Application")
Set newItem = Outlook.CreateItemFromTemplate("H:\apps\xp\Desktop\My Projects\DN.oft")

Set myRecipient = newItem.Recipients.Add(aTo)

'Debug.Print newItem.Recipients
newItem.Save
newItem.Display
      
       
Set newItem = Nothing

On Error GoTo 0

End Sub