Email addresses

G

Graham Hughes

I have an Access 2003 database of several hundred contacts, which I want to
import into Outlook. I have been able to do it, but the email addresses
would not import correctly.
eg. (e-mail address removed)
would come out as
[email protected]#http://[email protected]
The email address field in Access is hyperlink, and in the field it displays
the address correctly.
If I change hyperlink to text, it shows the email address incorrectly - the
same as the imported version.

Now for the question...

Without re-typing all of the email addresses manually, how can I solve my
problem and get the email address shown correctly?
 
A

aaron.kempf

use outlook automation to recreate the contacts in outlook

if the data is dirty; i would reccomend retrying it some other way
copy it into excel and then reimport from excel or soemthign along
those lines

how did you get where you are today?
 

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

Importing data from access 2
hyperlink field to send email 6
Why don't Outlook email addresses show up in a linked Access table 1
Email address in mailmerge using access 5
Access 2000 Email field format 4
How do I get rid of old email addresses in the drop-down box? 1
Outlook 2007 has messed up the email addresses for a lot of my contacts 0
List box 4

Top