Results 1 to 6 of 6
  1. #1
    Parker is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    76

    Why does my send to email button create this in TO: Email A.com#mailto: Email@.com#

    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];


  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Because Me.Combo242.Column(2) = the field [EmployeeT].[E-mail] and this field is formatted as hyperlink. Format as text.

  3. #3
    Parker is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    76
    Quote Originally Posted by ItsMe View Post
    Because Me.Combo242.Column(2) = the field [EmployeeT].[E-mail] and this field is formatted as hyperlink. Format as text.

    Thank you ItsMe, but how do I do that?

  4. #4
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    Edit the format in your table as per suggestion.

  5. #5
    Parker is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    76
    Quote Originally Posted by burrina View Post
    Edit the format in your table as per suggestion.

    I'm sorry, but what do I specifically do?

    Change the [EmployeeT].[E-mail] to Me.Combo242.Column(2) in the Combo Box Row Source?

  6. #6
    Parker is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    76
    Got it fixed, I understand now thank you all!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Command Button to Send Outlook Email
    By AJM229 in forum Forms
    Replies: 19
    Last Post: 05-07-2014, 09:05 AM
  2. Replies: 4
    Last Post: 02-05-2014, 04:05 PM
  3. Create Hyperlink and send via email
    By tcheck in forum Access
    Replies: 7
    Last Post: 11-20-2012, 06:24 PM
  4. Replies: 4
    Last Post: 04-13-2011, 10:11 AM
  5. send email to email addresses in database?
    By cnstarz in forum Access
    Replies: 5
    Last Post: 03-02-2011, 09:46 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums