Export Email Address from Access to Excel

[Guest]

Help, I am trying to export a query of email address from Access to Excel.
The field contains the bare email, for example (e-mail address removed). When I
export to Excel, the return is [email protected]#http://[email protected]#

What can I do just to return (e-mail address removed).

Thanks, and have a great weekend.

 

[Gary Walter]

"TinleyParkILGal"wrote:

Help, I am trying to export a query of email address from Access to Excel.
The field contains the bare email, for example (e-mail address removed). When I
export to Excel, the return is [email protected]#http://[email protected]#

What can I do just to return (e-mail address removed).

Thanks, and have a great weekend.

Hi,

Are you sure that the Access field contains
only the text (w/o the hidden "#...#")?

I have a db in Access 2002 that contains 2 fields

Email -- just the text
MailTo -- address w/ "#

for example:

EMail MailTo

(e-mail address removed) (e-mail address removed)#mailto:[email protected]#

when I run the following query,
I get *exactly* as above in new Excel worksheet

(NOTE: existing Excel file cannot be open if try to run this
to add a new worksheet to already existing xls file.
Obviously, if this will be a completely new xls file,
it cannot be "open," so no problem..)

SELECT
tblCustomers.CustName,
tblCustomers.EMail,
tblCustomers.MailTo
INTO [Excel 8.0;database=C:\email.xls].2007_11_10
FROM tblCustomers;

good luck,

gary

 

[Gary Walter]

"TinleyParkILGal"wrote:

Help, I am trying to export a query of email address from Access to
Excel.
The field contains the bare email, for example (e-mail address removed). When I
export to Excel, the return is
[email protected]#http://[email protected]#

What can I do just to return (e-mail address removed).

Thanks, and have a great weekend.

Hi,

Are you sure that the Access field contains
only the text (w/o the hidden "#...#")?

I have a db in Access 2002 that contains 2 fields

Email -- just the text
MailTo -- address w/ "#

for example:

EMail MailTo

(e-mail address removed) (e-mail address removed)#mailto:[email protected]#

when I run the following query,
I get *exactly* as above in new Excel worksheet

(NOTE: existing Excel file cannot be open if try to run this
to add a new worksheet to already existing xls file.
Obviously, if this will be a completely new xls file,
it cannot be "open," so no problem..)

SELECT
tblCustomers.CustName,
tblCustomers.EMail,
tblCustomers.MailTo
INTO [Excel 8.0;database=C:\email.xls].2007_11_10
FROM tblCustomers;

Just to be clear...

EMail is type Text
MailTo is type HyperLink

In textboxes on form they both show just the EMail text,
the "#...#" is not shown in MailTo (it is hidden).

But... if my user clicks on the text in a MailTo textbox,
it starts an email msg to that email address.