EmailDatabaseObject Automate TO Field

[Tlo]

I'm trying to email a form with the on click procedure of a button. I have built the "EmailDatabaseObject" macro within the on-click procedure, but am having difficulty with automating the TO field in the macro. The form is basically a punch list, and upon clicking this button I want the form to be emailed to the appropriate manager (i have labeled as "Assigned To" field on the form.) I have another field on the form that isn't visible that is the email address corresponding to the manager in the assigned to field. When I type =[Email] in the To field of the macro (Email is the name of the text box containing the email address) this is what i get in the to field when Outlook pops up: name@company.com#mailto:name@company.comHow can i get rid of the #mailto:name@company.com# portion of this?

It's the correct email address that is populating, but the #mailto:# portion is preventing Outlook from sending.

Please help!

[Tlo]

Any help? I was up till 2 am trying to figure this one out last night, any help is greatly appreciated!

[redbull]

Code example? Email questions get asked all the time, but having an example will prompt some help.

[Tlo]

Here is the code:

Private Sub Command23_Click()

Dim vRecipient As String
Dim vSubject As String
Dim vMsg As String

vRecipient = Me.Email
vSubject = "You Have Been Assigned a New Issue"
vMsg = "See attached for details."

DoCmd.SendObject acSendForm, "frmIssue", acFormatPDF, vRecipient, , , vSubject, vMsg, True

End Sub

It rendered the same result as the emaildatabaseobject macro when I put in the TO field =[Email] (where Email is the name of the text box containing the email address).