Results 1 to 5 of 5
  1. #1
    jmuirman1 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Aug 2016
    Posts
    84

    Email address field

    How do I change my 5000 email addresses from johndoe@abc.com#mailto:johndoe@abc.com# back to the normal email address. I think I tried to use hyper link and it changed all of my email addresses to the original email plus #mailto:xxx@xxx.com#?

    I wanted to have the email addresses be a hyperlink in my forms, but now on my mail letters the email address is shown as email@xxx.com#mailto:email@xxx.com#.


    Thanks,



    John

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    Did you adjust the properties for that column while in design view of your table? I prefer to store email addresses as text. There may be an easy fix, but I am going to guess the solution is to parse the extraneous text from the Hyperlink and use an update query to write the data to your production table.

  3. #3
    jmuirman1 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Aug 2016
    Posts
    84
    Thanks. how do I create a up querry?

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    An update query? You can create a query by clicking "Query Design" from within the Ribbon's Create tab. While in design view of a query object, you can click the Update tool to switch to an Update query.

  5. #5
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Try Len(Instr([NameOfField],"#")-1) to trim everything from the first # character when you create your update query. Put the expression in the Update To line of the query design grid. NOTE: as per my signature, test on a copy of your table first.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 3
    Last Post: 03-16-2016, 09:05 AM
  2. Email report to value (email address) in a field
    By JackieEVSC in forum Programming
    Replies: 7
    Last Post: 08-28-2015, 11:18 AM
  3. strEmai=.... - how to pick up Email Address field
    By Baldeagle in forum Programming
    Replies: 11
    Last Post: 08-05-2014, 03:07 PM
  4. email address field opens in Outlook?
    By pbouk in forum Forms
    Replies: 1
    Last Post: 06-04-2013, 03:29 PM
  5. Prompt for email address on field
    By burrina in forum Forms
    Replies: 9
    Last Post: 01-20-2013, 06:55 PM

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