Any way to make "E-mail Display As" column populate with the "E-mail" column data?
  Home FAQ Contact Sign in
microsoft.public.outlook.contacts only
 
Advanced search
POPULAR GROUPS

more...

microsoft ... contacts Profile…
 Up
Any way to make "E-mail Display As" column populate with the "E-mail" column data?         


Author: Jay Mueller
Date: Sep 17, 2008 14:20

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.
4 Comments
Re: Any way to make "E-mail Display As" column populate with the "E-mail" column data?         


Author: Russ Valentine [MVP-Outlook]
Date: Sep 17, 2008 15:22

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" gmail.com> wrote in message
news:dd3360e9-1f73-44e9-bdd5-7fa287df6391@s20g2000prd.googlegroups.com...
> 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...
Show full article (0.89Kb)
no comments
Re: Any way to make "E-mail Display As" column populate with the "E-mail" column data?         


Author: Diane Poremsky [MVP]
Date: Sep 17, 2008 20:23

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:
dailytips-subscribe-request@lists.outlooktips.net

EMO - a weekly newsletter about Outlook and Exchange:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM

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.
Show full article (1.22Kb)
no comments
Re: Any way to make "E-mail Display As" column populate with the "E-mail" column data?         


Author: Jay Mueller
Date: Sep 18, 2008 08:46

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.
no comments
Re: Any way to make "E-mail Display As" column populate with the "E-mail" column data?         


Author: Diane Poremsky [MVP]
Date: Sep 18, 2008 20:51

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:
dailytips-subscribe-request@lists.outlooktips.net

EMO - a weekly newsletter about Outlook and Exchange:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM

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.
Show full article (1.22Kb)
no comments