Export Email Address from Access to Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TinleyParkILGal - 09 Nov 2007 20:33 GMT

Help, I am trying to export a query of email address from Access to Excel.
The field contains the bare email, for example johnsmith@abc.com. When I
export to Excel, the return is johnsmith@abc.com#http://johnsmith@abc.com#

What can I do just to return johnsmith@abc.com.

Thanks, and have a great weekend.

Reply to this Message

Gary Walter - 10 Nov 2007 11:49 GMT

"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 johnsmith@abc.com. When I
[quoted text clipped - 3 lines]
>
> 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

gary@wrotein.msg gary@wrotein.msg#mailto:gary@wrotein.msg#

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

Reply to this Message

Gary Walter - 10 Nov 2007 12:07 GMT

> "TinleyParkILGal"wrote:
>> Help, I am trying to export a query of email address from Access to
[quoted text clipped - 37 lines]
> 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.

Reply to this Message