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.

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.