About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store


Hello everyone. Sorry for the lack of tips lately. A crush of end-of-the-year projects, plus having the kids out of school for the holiday has meant a lack of time. Look for the tips to return Jan 2nd.

Linda sent in today's question: One of my Outlook contacts is incorrectly set to send e-mail to the wrong address. I can change it, but the mail sent to the MyTeam distribution list still goes to the old address. Why?

Interesting problem. I wonder why Microsoft does not update the distribution lists automatically, but they don't.

Follow these steps, first to change the e-mail address and then update the distribution list.

  • In Outlook, make sure the folder pane is visible by selecting View from the menu, wait 3-5 seconds for the menu to expand, then see if there is a box around the icon next to Folder View. If there is not, then select Folder View.
  • You will not be able to see a list of personal folders on the left side of your Outlook Window. If necessary, press the plus sign next to your Personal Folders. Look for the folder called "Contacts" in the folder pane on the left side of the Outlook Window. Click Contacts.
  • In the right side of your Outlook window, you will see a list of all your Contacts. If necessary, use the scroll bar along the side or the bottom to find the entry for Cheryl N. Double-click on her name to open the contact record for Cheryl.
  • In the contact record for Cheryl, on the 2nd column, 5th row, click in the e-mail box, to the right of the existing e-mail address. Use the backspace key once and the wrong e-mail will disappear. Now, retype the correct e-mail (making sure to use instead of Tab out of the field and you should see the e-mail address change in the "Display As" field just below the e-mail field. Both the E-Mail and the Display As field should show the correct address.
  • Your changes are not correct until you press the Save and Close icon in the upper left corner.
  • Finally, and the most important step, if you have any Distribution Lists set up, you need to open this distribution list in the Contacts folder, and click the Update Now button on the right side of the dialog box. This will update the distribution list with the corrected e-mail.

By Bill Jelen on 29-Dec-2001 Consulting can be hired to implement this concept, or many other cool applications, with your data. provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.


Excel is a registered trademark of the Microsoft® Corporation.

All contents Copyright 1998-2008 by MrExcel Consulting.