--- description: If you find some contacts have no email address in your Outlook, you may want to process each Contact folder to delete all such contacts. This post will share 2 means with you. title: 2 Methods to Batch Delete All Contacts without Email Address in Your Outlook image: https://www.datanumen.com/blogs/wp-content/uploads/2017/12/batch-delete-all-contacts-without-email-address.jpg --- - - - [Home](https://www.datanumen.com/blogs/) > [Solutions](https://www.datanumen.com/blogs/category/solutions/) > [Office Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/) > [Outlook Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/outlook-solutions/) > 2 Methods to Batch Delete All Contacts without Email Address in Your Outlook # 2 Methods to Batch Delete All Contacts without Email Address in Your Outlook [Outlook Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/outlook-solutions/) September 29, 2025 Share Now: - - - - - - - - *If you find some contacts have no email address in your Outlook, you may want to process each Contact folder to delete all such contacts. This post will share 2 means with you.* Perhaps you have many contacts in your Outlook and some of them do not have email address. If you think that they are no longer useful, you must hope to delete all the contacts without email address. In the standard way, you can use “Instant Search” to find them and then delete them manually, like the following Method 1. Yet, it is a bit tedious. Therefore, in the Method 2, we will teach you another more efficient way.![Batch Delete All Contacts without Email Address in Your Outlook]( "Batch Delete All Contacts without Email Address in Your Outlook") ## Method 1: Manually Delete after Finding Contacts without Email Address 1. For a start, press “Ctrl + 3” keys to access “Contacts” pane. 2. Then, click in the search box. 3. Next, in the emerging “Search” ribbon, click “All Contact Items”. 4. Subsequently, click “Has Address” > “Has Email Address”.![Search All Contact Items]( "Search All Contact Items") 5. After that, “NOT emailaddresses:=\[]” criterion will be added into the search box. You need to remove the “NOT”.![Change Search Criterion]( "Change Search Criterion") 6. Subsequently, all the contacts with no email address will be listed. 7. Now, you should select contacts in the search results manually in that your contact groups must be in the list as well.![Select Contacts]( "Select Contacts") 8. Finally, press “Del” key button to delete all of the selected contacts. ## Method 2: Batch Delete All Contacts without Email Address with VBA 1. At first, tap on “Alt + F11” to launch VBA editor in Outlook. 2. In the new screen, copy the following VBA code into a module. ``` Sub BatchDeleteAllContactsWithoutEmailAddress() Dim objStore As Outlook.Store Dim lTotalCount As Long lTotalCount = 0 'Process all stores in your Outlook For Each objStore In Application.Session.Stores Call ProcessContactFolders(objStore.GetRootFolder.Folders, lTotalCount) Next MsgBox lTotalCount & " contacts are deleted!", vbInformation + vbOKOnly, "Delete Contacts" End Sub Sub ProcessContactFolders(ByVal objFolders As Outlook.Folders, lCount As Long) Dim objFolder As Outlook.Folder Dim i As Long Dim objContact As Outlook.ContactItem Dim objSubfolder As Outlook.Folder For Each objFolder In objFolders If (objFolder.DefaultItemType = olContactItem) And (objFolder.Name <> "Skype Contacts") Then For i = objFolder.Items.Count To 1 Step -1 If objFolder.Items(i).Class = olContact Then Set objContact = objFolder.Items(i) 'Delete the contact w/o email address If (objContact.Email1Address = "") And (objContact.Email2Address = "") And (objContact.Email3Address = "") Then objContact.Delete lCount = lCount + 1 End If End If Next 'Process subfolders recursively If objFolder.Folders.Count > 0 Then Call ProcessContactFolders(objFolder.Folders, lCount) End If End If Next End Sub ``` ![VBA Code - Batch Delete All Contacts without Email Address]( "VBA Code - Batch Delete All Contacts without Email Address") 3. Later, click in “BatchDeleteAllContactsWithoutEmailAddress” subroutine. 4. Eventually, press “F5” to trigger this macro. 5. When it completes, you would get a message about the results, like the image below.![Prompt of the Results]( "Prompt of the Results") 6. All the contacts without email address have been moved to “Deleted Items” folder.![Deleted Contacts]( "Deleted Contacts") ## Keep Far Away from All Potential Risks Outlook can get damaged due to a variety of factors, such as viruses, user errors, software failures as well as hardware faults. You must be reluctant to experience Outlook damage, so you need to keep all these potential risks at bay. For instance, you need to mount potent antivirus software on your PC. Plus, you have to back up your Outlook data on a regular basis. Last but not least, you’d better prepare a robust and reliable repair tool, such as DataNumen Outlook Repair. It can fix your [corrupt PST](https://www.datanumen.com/outlook-repair/) file with ease. ## Author Introduction: Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including [SQL Server corruption](https://www.datanumen.com/sql-recovery/) and outlook repair software products. For more information visit [www.datanumen.com](https://www.datanumen.com/) Share Now: - - - - - - - - [← Previous post](https://www.datanumen.com/blogs/implement-conditional-formatting-continuous-form-ms-access/) [Next post →](https://www.datanumen.com/blogs/batch-remove-attachments-outdated-calendar-items-outlook/) Comments are closed. ![Data Recovery Blog]() Follow or like us on Facebook, LinkedIn and Twitter to get all promotions, latest news and updates on our products and company. - - - ### Featured Products - [DataNumen Outlook Repair](https://www.datanumen.com/outlook-repair/) - [DataNumen SQL Recovery](https://www.datanumen.com/sql-recovery/) - [DataNumen Exchange Recovery](https://www.datanumen.com/exchange-recovery/) - [DataNumen Access Repair](https://www.datanumen.com/access-repair/) - [DataNumen Excel Repair](https://www.datanumen.com/excel-repair/) - [DataNumen PDF Repair](https://www.datanumen.com/pdf-repair/) - [DataNumen Word Repair](https://www.datanumen.com/word-repair/) - [DataNumen Zip Repair](https://www.datanumen.com/zip-repair/) ### Popular posts ```json {"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.datanumen.com\/blogs\/2-methods-batch-delete-contacts-without-email-address-outlook\/#article","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/2-methods-batch-delete-contacts-without-email-address-outlook\/"},"author":{"name":"AuthorCCW","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957"},"headline":"2 Methods to Batch Delete All Contacts without Email Address in Your Outlook","datePublished":"2017-12-13T03:26:22+00:00","dateModified":"2025-09-29T09:10:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/2-methods-batch-delete-contacts-without-email-address-outlook\/"},"wordCount":438,"commentCount":0,"publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/2-methods-batch-delete-contacts-without-email-address-outlook\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/12\/batch-delete-all-contacts-without-email-address.jpg","articleSection":["Outlook Solutions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.datanumen.com\/blogs\/2-methods-batch-delete-contacts-without-email-address-outlook\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.datanumen.com\/blogs\/2-methods-batch-delete-contacts-without-email-address-outlook\/","url":"https:\/\/www.datanumen.com\/blogs\/2-methods-batch-delete-contacts-without-email-address-outlook\/","name":"2 Methods to Batch Delete All Contacts without Email Address in Your Outlook","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/2-methods-batch-delete-contacts-without-email-address-outlook\/#primaryimage"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/2-methods-batch-delete-contacts-without-email-address-outlook\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/12\/batch-delete-all-contacts-without-email-address.jpg","datePublished":"2017-12-13T03:26:22+00:00","dateModified":"2025-09-29T09:10:57+00:00","description":"If you find some contacts have no email address in your Outlook, you may want to process each Contact folder to delete all such contacts. This post will share 2 means with you.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.datanumen.com\/blogs\/2-methods-batch-delete-contacts-without-email-address-outlook\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/2-methods-batch-delete-contacts-without-email-address-outlook\/#primaryimage","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/12\/batch-delete-all-contacts-without-email-address.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/12\/batch-delete-all-contacts-without-email-address.jpg","width":1996,"height":979,"caption":"Batch Delete All Contacts without Email Address in Your Outlook"},{"@type":"WebSite","@id":"https:\/\/www.datanumen.com\/blogs\/#website","url":"https:\/\/www.datanumen.com\/blogs\/","name":"Data Recovery Blog","description":"Discuss every aspect of data recovery","publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.datanumen.com\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.datanumen.com\/blogs\/#organization","name":"Data Recovery Blog","url":"https:\/\/www.datanumen.com\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","width":296,"height":397,"caption":"Data Recovery Blog"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataNumen","https:\/\/x.com\/DataNumen","http:\/\/www.linkedin.com\/company\/datanumen","https:\/\/myspace.com\/datanumen\/","http:\/\/www.pinterest.com\/datanumen\/","https:\/\/www.youtube.com\/channel\/UCVIIuuKfUBHSJauUaVP13tw"]},{"@type":"Person","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957","name":"AuthorCCW","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","caption":"AuthorCCW"},"sameAs":["https:\/\/www.datanumen.com\/"]}]} ```