if then statement to send emails

Hi


i have a cell b12 in my excel sheet .

I have the following conditions :-

if cell b12=Private then email attachment to a given email address
if cell b12=Public then email attachment to a given email address

how to do this in vba.

rakesh

How did you make this thread, I want to post something too but I don't know how to post as I am new in this site. Hope you don't mind it.