Export Email Address from Access to Excel

  • Thread starter TinleyParkILGal
  • Start date
G

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 [email protected]. When I
export to Excel, the return is [email protected]#http://[email protected]#

What can I do just to return [email protected].

Thanks, and have a great weekend.
Click to expand...

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

[email protected] [email protected]#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
 
G

Gary Walter

Gary Walter said:
"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 [email protected]. When I
export to Excel, the return is
[email protected]#http://[email protected]#

What can I do just to return [email protected].

Thanks, and have a great weekend.
Click to expand...

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

[email protected] [email protected]#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;
Click to expand...

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.
 
Top