• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1785
  • Last Modified:

automated populate email address field in Active Directory


I have an OU with 800+ users in it and i need to populate the email address field with 'firstname.surname@domain.com'

I was hoping to use something similar to '%username%@domain.com' which does work in the email address field in AD but its not the username that i need. Tried using %givenname%.%sn%@domain.com but didn't work.

Has anyone just a similar command to populate this field before or can advise the best way to do this without having to input manually.

1 Solution
If you are running exchange you can do this through recipient policies en masse.
do this
use this tool to modofy the email addresses in bulk

you can get  admodify.net from codeplex.com or just google
Thank you
NoelMCMAuthor Commented:
Just to note and i should have mentioned in the first post. We are a Lotus Notes house so the email address field in AD will purely be for reporting purposes.

Not having Exchange will i still be able to use the admodify without any issues do you know?

Thanks for the quick responses by the way!!
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

NoelMCMAuthor Commented:
Tried using ADModify but i still end up with the same issue in that i still have to type in what i want to appear. See attachment
If you are open to using PowerShell with Quest Cmdlets, then below script may suffice for you.
get-qaduser -searchroot 'na.mydomain.int/users and groups' -email $null -firstname * -lastname * -sl 0 | foreach {
    $email = "{0}.{1}@{2}" -f $_.firstname,$_.lastname,$_.userprincipalname.split("@")[1]
   write-host $email
    #set-qaduser -identity $_ -email $email

Open in new window

do it from the Email addresses tab
there you have options to define it the way you want
with a example
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now