I have a button on a form that when submitted has an email automatically generate in my Lotus Notes. The email TO: line is gerenated from a combo box selection the user makes.
My problem is in the TO: line the email address looks like this
email @email.com#mailto:email @email.com#
AKA it adds on (#mailto:email @email.com#)
Anyone know how to remove this?
My code is:
Private Sub Submit_Record_Click()
DoCmd.SendObject _
, _
, _
, _
Me.Combo242.Column(2), _
, _
, _
"***A new Lab Report has been submitted for your review***", _
"Hello," & vbCrLf & vbCrLf & vbCrLf & "Please log into the Lab Report Database and review the latest pending report. If you have any questions please contact the sender." & vbCrLf & vbCrLf & "This is an automated response generated from Microsoft Access." & vbCrLf & vbCrLf & vbCrLf & "Sincerely," & vbCrLf & "Lab Report Database", _
False
My combo box row source statement is
SELECT [EmployeeT].[Employee_ID], [EmployeeT].[Last_Name], [EmployeeT].[E-mail] FROM EmployeeT ORDER BY [Last_Name];