Any way to make "E-mail Display As" column populate with the "E-mail"column data?

[Jay Mueller]

Been trying to solve this problem from multiple vectors, but I'm
hitting walls, left, right, and center. For whatever reason I've got
the better part of 7000 contacts that have a sprinkling of "E-mail
Display As" data that is out of sync. Is there any script or other
solutions for identifying these fields and pushing the e-mail field
data into the e-mail display as field? Tried query builder and even
tried my hand using the SQL queries to filter them so I could find out
of sync contacts...but no dice.

Any help would be extremely welcome. Thanks in advance.

 

[Russ Valentine [MVP-Outlook]]

Not sure what you mean by "out of sync." Just curious. Why do you think the
EDA field is of such consequence that you must go to all this effort?

 

[Diane Poremsky [MVP]]

What version of outlook?

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
(e-mail address removed)

EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.

 

[Jay Mueller]

Outlook 2003/2007 on Exchange 2003.

The software package that is currently being used updates only the e-
mail field, not the e-mail display as field...which unfortunately
another application pulls from. Needless to say they end up being
'out of sync', as in the EDA shows the out-dated e-mail address.

 

[Diane Poremsky [MVP]]

what do you want in the email display name field?

You can use this VBA code: http://www.slipstick.com/contacts/file-as.htm
changing the .fileas portion of the code to something like this:
.Email1DisplayName = .Email1Address
This will use the email address as the display name.


--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
(e-mail address removed)

EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.