Powershell Script to manage creating users account, and Mailboxes from Excel .csv file.

Need help with creating a very, very clean working powerShell that can.

1. check .csv file for duplicates user 1st and last name, and remove duplicates, then export

a new excel .csv file that has been clean of duplicates.

2nd. From the new clean excel .csv file, 1st Check Active Directory to see if users already have an account created in Active Directory, if so, place the users in an excel file name ( UsersAlreadyInAD), and if not in Active Directory, create the users an Accounts in Active Directory, and place the users in the assigned OU / PrimaryAfflliation Group assigned to them in the in [login to view URL] file in Active Directory.

3rd. Check if Mail in ExchangeOnline Exist for users in the .csv file, if mail box exist, place user in Excel file name (UsersAlreadyHaveMailbox), then have script continue and create users Mailboxes that don't have Mail in our ExchangeOnline (Office365 Environment).

4the, have script email user's the new email with a create password with it being at least 12 mixed charters, and a link within the email for users to use to login to the mailbox, and a custom message area, and after script completes, have it print out a report of all accounts successfully created to a pdf file with the current date and named "03_7_21NewUsersAccountsReport"

If I am missing something, do advise me, but this is basically what I need and i need it by Thursday Evening 3/5/21

Break script into parts running one section of code at a time, with clearly comments that explain what's happening at each stage of the script, clean up script.

Skills: Microsoft Exchange, Office 365, Windows Server, Process Automation, Powershell

See more: start excel csv file, excel csv file format, powershell script create multiple users, read excel csv file plsql, excel csv file grapher, create excel csv file web page, creating multiple account via excel, creating users active directory excel sheet, excel csv file schema, macro export range data excel csv file, powershell script create ad users excel file, vba create excel csv file, excel csv file template, import excel csv file macro access, data manipulation excel csv file, powershell script to create users in active directory, powershell script to compare users group membership

About the Employer:
( 4 reviews ) Athens, United States

Project ID: #29448892

Awarded to:


I am an experiences Powershell Engineer with experience around 3 years in powershell Coding. I have a script written before which is similar to this one.

$156 USD in 7 days
(1 Review)

10 freelancers are bidding on average $152 for this job


Powershell Expert.... Hey There, Greeting for the day.... I am Microsoft Certified administrator with 12+ years of experience. I very good in powershell scripting. I can prepared automated script to get your job done More

$200 USD in 2 days
(33 Reviews)

Hello I think I can help you I am a system engineer with 18+ years of experience of Microsoft server products, especially (but not limited to) Active Directory, Exchange Server and slightly less Hyper-V and MS SQL Serv More

$250 USD in 5 days
(1 Review)

Hi Client , I already done many similar tasks and I can close this task quickly. I’m a Senior Software Developer & Freelance Web & Automation developer with 7+ years of experiences with Master degree holder and exp More

$30 USD in 1 day
(8 Reviews)

Senior Powershell , Microsoft exchange , automation , windows server expert. As 14+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide More

$150 USD in 2 days
(1 Review)

Hello, I can make script for You. in my opinion it is easy work so i can do it for You very fast. If You want please contact me , I can start just right now

$70 USD in 2 days
(1 Review)

Hi, I have 10 + years of experience in managing remote infrastructire of multiple clients across the globe. I have good experieince on Active directory and powershell scripting. Given a chance, I would be happy to hel More

$190 USD in 3 days
(0 Reviews)

Hi, I am a Powershell expert and can complete your project as per your expectations. I have in-depth knowledge of, O365, AD and powershell thereby making me a suitable candidate for your project.

$300 USD in 7 days
(0 Reviews)

I am a system engineer and I am 5 years experience with PS scripting which I believe can sort it out

$120 USD in 3 days
(0 Reviews)

I have +4 years experience with automation scripts and C# programing language. that's all what I need to say thanks

$50 USD in 7 days
(0 Reviews)