In my Outlook Address Book Contacts I have entries "Display Name" in three
different format. One
Names only, one email address only. and third one Names and email address in
brackets. I face the same problem when I enter a new contact details for
"Display As". I also
import addresses from Access tables. On technical grounds which is the best
option?

Please answer also which is the best choice to export/import to an external
program. Access or Excel.

It doesn't really matter which program you import from. They should all use
the default display as settings unless they define a display name field.

You can use VBA to change the email display names and file as names, if you
want them uniform.
See http://www.slipstick.com/contacts/file-as.htm
and http://www.slipstick.com/contacts/emaildisplayname.htm

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:
dailytips-subscribe-(E-Mail Removed)

EMO - a weekly newsletter about Outlook and Exchange:
EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


"Tatar" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> In my Outlook Address Book Contacts I have entries "Display Name" in three
> different format. One
> Names only, one email address only. and third one Names and email address
> in
> brackets. I face the same problem when I enter a new contact details for
> "Display As". I also
> import addresses from Access tables. On technical grounds which is the
> best
> option?
>
> Please answer also which is the best choice to export/import to an
> external
> program. Access or Excel.
>
>

Kindly do not multipost. We have plenty to do as it is.
--
Russ Valentine
[MVP-Outlook]
"Tatar" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> In my Outlook Address Book Contacts I have entries "Display Name" in three
> different format. One
> Names only, one email address only. and third one Names and email address
> in
> brackets. I face the same problem when I enter a new contact details for
> "Display As". I also
> import addresses from Access tables. On technical grounds which is the
> best
> option?
>
> Please answer also which is the best choice to export/import to an
> external
> program. Access or Excel.
>
>