Verifying Email addresses etc using macros
 

I get this Excel sheet everyday which contains email addresses,
sometimes even 10000 rows in each. I would like to run a macro that
verifies the email address format (*@*.*) and verifies that it has no
spaces or no blank rows. There are other columns too in the sheet,
where I need to verify that none of the rows in those columns are
empty.
I have never written macros before, please help.

Thanks in advance !