need a script that can pick data from an excel sheet and email it to someone

Hi, i need a script that can pick out just a cell from a column in an excel sheet and email it to someone else given that there's no data on any cell in its row. Pls, can someone give dis a try

we are here to help you, not write it for you
do you want to do this from within excel?

if you search this forum you will find many examples on using CDO.message to send emails, in this or office development forums, you will find many examples on automating outlook to send emails

Moved to the Office Development Forum.

welcome to the forum,
see this link