Manage Learn to apply best practices and optimize your operations.

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.
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 last published in January 2005

Dig Deeper on Exchange Server setup and troubleshooting

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.