Changing E-mail Addresses in Bulk

Changing E-mail Addresses in Bulk

How can I define a second SMTP e-mail address, specify that the new e-mail address be the reply address, and retain the old address easily for many (>1000) users?

Probably the easiest way to do this is to do a Directory Export in Exchange Administrator to create a .CSV file, and then open that .CSV file in Excel.

  1. If you don’t already have one you’ll need to add a column called “Secondary-Proxy-Addresses” (no quotes).
  2. Select the column with your primary SMTP addresses and drag to move those to the new column you just created.
  3. Now you’ll need to create the new primary addresses. Without any details of your mailboxes or what the new addresses are, I can’t really get very specific on how to create them in Excel?but Excel has a variety of tools, from the Fill Handle to nifty functions and macros that can automate (to varying degrees) the process of filling in data.
  4. Once you’ve got all your new primary addresses created, save that file as a .CSV file (Comma-Separated Values) and then do a Directory Import of that file back into Exchange.

I shouldn’t have to tell you that it’s a good idea to have a full backup of your Exchange server before you do things like this…but I guess I just did.

CAUTION: One thing to watch out for?be sure to use a recent version of Excel (like Excel 2000) because older versions have a limit of 255 characters in a cell, so lengthy distribution lists would get truncated.

Share the Post:
Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular

XDR solutions

The Benefits of Using XDR Solutions

Cybercriminals constantly adapt their strategies, developing newer, more powerful, and intelligent ways to attack your network. Since security professionals must innovate as well, more conventional endpoint detection solutions have evolved

AI is revolutionizing fraud detection

How AI is Revolutionizing Fraud Detection

Artificial intelligence – commonly known as AI – means a form of technology with multiple uses. As a result, it has become extremely valuable to a number of businesses across

AI innovation

Companies Leading AI Innovation in 2023

Artificial intelligence (AI) has been transforming industries and revolutionizing business operations. AI’s potential to enhance efficiency and productivity has become crucial to many businesses. As we move into 2023, several

data fivetran pricing

Fivetran Pricing Explained

One of the biggest trends of the 21st century is the massive surge in analytics. Analytics is the process of utilizing data to drive future decision-making. With so much of

kubernetes logging

Kubernetes Logging: What You Need to Know

Kubernetes from Google is one of the most popular open-source and free container management solutions made to make managing and deploying applications easier. It has a solid architecture that makes

ransomware cyber attack

Why Is Ransomware Such a Major Threat?

One of the most significant cyber threats faced by modern organizations is a ransomware attack. Ransomware attacks have grown in both sophistication and frequency over the past few years, forcing