Deleting entire customer entry if one cell is blank?

I have a large database of customers. I would like to edit this database so that it only lists those customers that have an email address listed in that particular column. I can then save that as a separate list to upload to my marketing campaign.

Is there an easier way than just deleting entire rows at a time? About a 2,000 name list with maybe 30% having email addresses.

Deleteing rows requires code. You'll find many examples if you search the forum for 'delete rows.' If you don't find one that suits you, post back.

Or you could just sort by email address, and then delete the blank rows, which will all be together.

Or Autofilter.

You could use AutoFilter to show only the rows with the blank e-mail entry and then delete those rows en mass.