Results 1 to 3 of 3
  1. #1
    cmk is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    May 2016
    Posts
    4

    Exporting Access Email addresses to Excel

    Not sure if this is strictly an Access question or Excel question, but here goes. I have a contacts database in Access 2016, but because of the amount of columns, I've got to export data to a linked Excel workbook since there's more flexibility in formatting/printing out the report and such. The issue is, the email field from Access exports the email addresses in this format: Instead of just the regular email address exporting (i.e., Anybody@gmail.com), it exports as Anybody@gmail.com#mailto:Anybody@gmail.com#. Am I doing something wrong from the Access end? The email field is set as a Hyperlink field. Or, from the Excel end, is there a way to do some VBA or something so that the addresses that show up will show only as Anybody@gmail.com? Thank you very much.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Options are to not use hyperlink field or parse the hyperlink string with string manipulation functions.

    Left([fieldname], InStr([fieldname],"#")-1)

    But if you want the value in Excel to display as a hyperlink, I think that will require modifying the value after export to Excel or formatting the column. Here is one discussion https://stackoverflow.com/questions/...links-in-excel
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    cmk is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2016
    Posts
    4
    Thank you for the info and the link for additional info. All of this was exactly what I was looking for.

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

Similar Threads

  1. Replies: 1
    Last Post: 01-16-2017, 07:50 PM
  2. Problem exporting multi-line addresses to Excel
    By mjwillyone in forum Import/Export Data
    Replies: 4
    Last Post: 01-27-2016, 11:01 AM
  3. Access storing email addresses
    By cbende2 in forum Access
    Replies: 12
    Last Post: 01-05-2015, 01:25 PM
  4. Replies: 2
    Last Post: 10-09-2014, 01:32 PM
  5. Exporting Outlook email addresses
    By noidea in forum Import/Export Data
    Replies: 0
    Last Post: 08-01-2009, 01:48 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