Unfortunately I just have the email addresses.

I know I can get the primary key for an individual record using a
select statement like the one below.
use maindb
go
select *
from dbo.tblLead
where email = 'bad@address.com'

Is there a way to use the excel list in the place of the single bad
address and then dump the results into a new table?  Then do the
update as described below as a separate process?  If I wanted to just
delete bad addresses where I don't have a new address and leave the
rest of the lead information alone could I do that using an Inner join
in my update?  All references I have found to the delete statement
talk about deleting entire rows of data and I don't want to do that.

Chris

Unfortunately I only have a list of addresses.  I know I can retrieve
the primary key associated with an individual address using the
following select statement or somehting similar.

use leaddb
go
select primary_key, email
from dbo.tblLead
where email = 'bademail@address.com'

Is it possible to use a variable in the where statement that picks up
the data in the excel file and then dumps the results into a table for
the purposes of doing the update as described below?  Also if I don't
have a new address to update with how do I delete the email address
but leave the rest of the record in tact?  All of the references I
have seen to the DELETE statement refer to deleting rows from the
table.  I don't want to do that - only the email address.