Ask the Expert

How to update multiple mailbox properties

What is the best way to update a user's mailbox properties if I need to do 300 of them? I currently have a spreadsheet with their new information, such as their positions, offices and telephone numbers.

    Requires Free Membership to View

Your options are to write a script or to use a tool such as LDIFDE. LDIFDE is the most common way to do what you're trying to do:

1. Export your directory using LDIFDE.

2. Then reformat the export into a spreadsheet-compatible format (such as comma-delimited or tab-delimited).

3. Import into Excel and make your changes.

4. Export from Excel to delimited and reformat back into LDIFDE-ready input.

5. Finally, import back into your Active Directory.

Hint: There are a few readily available utilities available to convert between spreadsheet-compatible and LDIFDE-compatible formats.

Do you have comments on this Ask the Expert question and response? Let us know.

This was first published in January 2005

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: