SendObject - HTML tags in 'To' field

[Hello World]

Solved it - I was inputting the email address as a hyperlink.





Howdy!

I am using the SendObject feature to email a report in Text format from a Form. The report is based on a query. The code which I am successfully using is this:

 Private Sub Email_Click()
DoCmd.SendObject acSendReport, "EmailReport", acFormatTXT, Me!Managers_email, , , "ACTION REQ. Employee Terms and Conditions", "The following employee has blah blah blah...", True
End Sub

When executed the above creates the email but in the 'To' box the email address appears as this:

john.doe@here.gov.uk#<a href="http:/...ere.gov.uk</a>#

Any know why it is inserting these HTML tags?

[Stingaway]

Love it when the post is answered by the person who posts it. Thanks for following up!