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.

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?
--
Russ Valentine
[MVP-Outlook]
"Jay Mueller" wrote in message
...
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.

What version of outlook?

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

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


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


"Jay Mueller" wrote in message
...
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.

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.

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: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


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


"Jay Mueller" wrote in message
...
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.