Use Excel VBA to add a hyperlink to a word document

I have a word template that I open (as a new document) with excel VBA.
This template has bookmarks in it and I can copy and paste text or cell values from excel to the template to fill it out automatically. The one area I am having problems is in trying to create an email hyperlink in one of my bookmarks.

Does anybody have any suggestions?
Here is an example of the code I am using that does not work correctly:

Sub Hyperlink()
Dim wb As Excel.Workbook
Dim wdApp As Word.Application
Dim myDoc As Word.Document
Dim LinkName As String
Dim LinkAddress As String
Dim SPE, SCM, Purch, SQE, Vendor, Veri As Boolean

Set wb = ActiveWorkbook
Path = wb.Path & "\Test.dotm"
'On Error GoTo ErrorHandler

'Create a new Word Session
Set wdApp = CreateObject("Word.Application")
     
'Open document in word
Set myDoc = wdApp.Documents.Add(Path)

'Activate word and display document
  With wdApp
    .Visible = True
    .ActiveWindow.WindowState = 0
    .Activate
  End With

LinkName = "Name Here"
LinkAddress = "Email@Address.com"
  With myDoc.Bookmarks
    .Item("Bookmark2").Range.InsertBefore LinkName
    .Item("Bookmark2").Select
    With Selection
      .Hyperlinks.Add Anchor:=Selection.Range, Address:="Mailto:%20" & _
      LinkAddress, SubAddress:="", ScreenTip:="", TextToDisplay:=LinkName, Target:=""
    End With
  End With
End Sub

I have tried several variations on this and cannot seem to get it to work. I can paste the "LinkName" to the bookmark and select the bookmark just fine, but I cant get the hyperlink to attach.

Any help would be greatly appreciated.
Rick

P.S. I am using Office 2007 for this project. The Macro starts and runs in excel which then opens the word document. I wasn't sure if any of that was clear or not.