Access - Sending outlook template email from button

[SShort]

The code below is producing name@email.com#mailto:name@email.com# in the to field of the email. How do I fix the code so it will only produce name@email.com?

Dim myOlApp As Outlook.Application
Dim MyItem As Outlook.MailItem
Set myOlApp = CreateObject("Outlook.Application")
Set MyItem = myOlApp.CreateItemFromTemplate("C:\samplefile.oft" )
MyItem.To = Email


MyItem.Display

[Welshgasman]

Inspect what is in the template email first?
Use .display or look at the template in outlook.
Even look at what Email contains.?

[pbaldy]

I suspect your email field has the hyperlink data type:

https://codekabinett.com/rdumps.php?...link-data-type