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