email addresses double when exporting query to excel

  • Thread starter Thread starter frandk
  • Start date Start date
F

frandk

When I exported a query to excel the column that holds the email addresses
adds after the .com - #mailto:then the original email address again with
another pound sign at the end. What am I doing wrong.
 
Nothing is wrong but mailto: is a hyperlink and a hyper link has three
parts. You only see the display part.
display text # file name # any reference within the file

Read this site to understand how it is stored and then you will see why your
export looks like it does.
http://allenbrowne.com/casu-09.html
 
Tks Pete, It's amazing what they do NOT explain in class at the community
college. I understand from reading what you attached, that to make it
easier for the user, you do not see or have to do all the steps it takes to
execute something. So, am I clear that this means it will always export from
access into excel with the three parts of the hyperlink displayed.
 
You can format excel to hyperlink and it should display correctly. Be
honest with you most of mine go from excel to access. Might ask about this
in an excel group also.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2007 Microsoft Office - Export from Access to Excel 1
Export Access 2007 reports/queries to Word 2007 documents 1
Exporting multiple queries into Excel workbook tabs 10
Exporting to Excel 2007 1
Export Query to Excel 1
The Export Pound Sign or number sign 4
export email addresses to Outlook 3
How? Export email addresses in a query to To field in Outlook mes 2

Back
Top