XADM: Creating First/Last Names for MS Mail Custom Recipients

• Microsoft Exchange Server, version 4.0

SUMMARY

When you use Directory Synchronization between Microsoft Exchange and Microsoft Mail, custom recipients are created on the Microsoft Exchange side for each Microsoft Mail user.

When you look at the properties of the created custom recipients, the Firstname and Lastname fields are empty. This is because, on the Microsoft Mail side, each account has only a Display Name and there are no separate fields for the first and the last names. As a result of this, when the custom recipients are created on the Microsoft Exchange side, there is no information available to fill the Firstname and Lastname fields of the custom recipients.

Empty Firstname and Lastname fields can cause address resolution from the client to behave differently than that for Microsoft Exchange mailboxes. This might be noticed in the client, when the Check Names command does not bring up a list of all possible matches and does not find Microsoft Mail custom recipients created during Directory Synchronization. The reason for this is that the Check Names command uses the Lastname and Firstname fields for Address Resolution. For more information on how the Check Names command works, please refer to the following article:

   Article ID: Q147400
   TITLE     : XCLN: How the Check Names Command Works

MORE INFORMATION

The process of modifying the custom recipient information involves exporting the custom recipient data to a text file, modifying this text file, and then re-importing this data back into the Microsoft Exchange directory. The steps below indicate how this is done.

The following steps refer to Microsoft Excel 7.0. Most other spreadsheet programs can also be used. We assume that Directory Synchronization has been used to create the Microsoft Mail custom recipients and that these recipients are created in a recipient container called MS Mail Users. The Display name of the custom recipients is assumed to have the format: <FirstName> <LastName>

1. From the Microsoft Exchange Administrator program, select the Directory

       Export command from the Tools menu.
   

    Users).

    the file selected (Msmail.csv).

    that can read delimited text files.

For the rest of the steps we assume that the rows are labeled numerically and the columns alphabetically. In other words, the rows start from 1, and the columns from A.

1. Search for the field, First Name. Normally this field should be in

       Column B.
       Search for the field, Last name. Normally this field should be in
       Column C.
       Search for the field, Display Name. Normally this field should be in
       Column D.
   

    and should be empty.
    Type in =LEFT(D2,FIND(" ",D2)-1).
    Hit the Enter key.
    Cell B2 should now have the first word of the contents of Cell D2.
    Assuming that Display Name has the format: <FirstName> <Last Name>,
    cell B2 should contain the first name of the custom recipient.

    and should be empty.
    Type in =RIGHT(D2,LEN(D2)-LEN(B2)-1).
    Hit the Enter key.
    Assuming that Display Name has the format: <FirstName> <Last Name>,
    cell C2 should contain the last name of the custom recipient.

    Move the mouse cursor to the bottom right corner of this cell. The
    cursor should now change to a + (plus) sign.

    drag the cursor to the last row. Now release the left mouse button.
    For each row, Column B should now be filled with the first name of
    the custom recipient specified in that row.

    Move the mouse cursor to the bottom right corner of this cell. The
    cursor should now change to a + (plus) sign.

    drag the cursor to the last row. Now release the left mouse button.
    For each row, Column C should now be filled with the last name of
    the custom recipient specified in that row.

    Directory Import command from the Tools menu.

    Mail custom recipients we just modified. Each custom recipient should
    now have the First and Last name fields populated.