We are currently working on a project that is a large chart.

we have peoples names in column A, email addresses in column B, and things
they are missing from column C-G.

What we are doing is basically placing an x under what is missing to show
that we need to contact them with that information.

The list is quite large.

so far we have it so it can look to see who has been sent an email already
and who hasn't in order to identify who needs the email sent. So it selects
everyone who needs the email, then it pulls the information that is needed
from the columns, pulls it into an email, and then all I have to do is click
send.

what we want is the second part to the formula that will only send the
headers to the columns that have an x placed under it.

Any help is appreciated.

--
Message posted via http://www.officekb.com