Export to Excel

[Ann Shaw]

Hi
If anyone could help me I would be grateful!

I have email address as one of the fields in my Access
Database but when I export to Excel it shows up with extra
strings??

Example
In Access - field contains [email protected] but
in Excel it shows as
[email protected]#http://john.purdy@smartbusiness
..ie#
I have to have these email addresses in Excel.

Many thanks in Advance.

Ann

 

[John Nurick]

Hi Ann,

Are the addresses stored in a hyperlink field in Access? If so, try
creating a query with a calculated field
Tmail: HyperlinkPart(, 0)
to return the hyperlink field contents as text.

If necessary, experiment with different values instead of 0 (1,2,3 or 4
perhaps). These correspond to the named constants described in VBA help
for the HyperlinkPart function, but you have to use the actual numeric
values if you call the function in a query.