First, Leads cannot be deactivated. They can either be Disqualified or Deleted. Both can be done, but the process is a bit different
- You could use the Advanced Find, "Export and Re-Import" feature to accomplisgh you goal.
- Your Advanced Find should have the Full Name, Email Address and Status Fields as Columns.
- Run the Query and Export the result to an Excel Worksheet.
- At least 3 blank Columns to the Right of the Table, copy your email addresses that you wish to Disqualify
- It should be sorted by Email Address
- Create a Range Name for your copied Table
- I use one Letter like "L" for Leads
- In the Column to the right of your Table, add the following Formula
- =VLOOKUP([@Email],L,1,FALSE)
- False is very Important so it will result in "#N/A" if it is not found
- The new Column will be called "Column1"
- Sort by "Column1" and all of the tagged Emails will rise to the top
- Hopefully it will match the Rows from you copied Table (L)

- Delete the full rows of all the Leads that end with "#N/A"
- Change the Status for all remaining rows to "Disqualified"
- Save the Worksheet with some meaningful name like "Disqualify Leads (###)"
- I like to put the number of Rows I am affetcing in the name as a Proof of the change
- Import the saved Table back into CRM
- When the Import is complete, all of your Leads will be updated as "Disqualified/Deactivated"
If you have over 50,000 Leads, you will need to be a bit more Creative with you Exports. One idea would be to create subsets of the Export based on Creation Date
If you need to Delete the Leads, add an unused text Column to your Query. Add some Keyword to the Column like "Delete" and Import the Worksheet back in to CRM. Now you can seacrh for Leads based on the Data in that Column and do a Bulk Delete of your Leads
------------------------------
Gerry Yurko
Sofware Engineer III
Crown Castle Fiber Networks
Boxborough MA
------------------------------
Original Message:
Sent: Aug 25, 2022 07:27 AM
From: Deepak Karavadra
Subject: Is it possible to look up Leads by multiple email addresses at once in Dynamics 365?
Hi,
I need to de-activate a number of leads in our Dynamics 365 system but all I have is a spreadsheet with their Full Name and email addresses.
With email addresses being unique is there a way I can look up all the leads in CRM using the multiple email addresses in the spreadsheet?
Using Advanced Find it looks like I can only search one lead at a time using one email address at a time.
Regards.
------------------------------
Deepak
------------------------------