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:
Code:
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?