Sorry to be confusing.

What I have is a report that shows projects that remain outstanding.
Associated with each project is a zone (or zones) that it is related to
(IE: Central, North, East, West). Each zone has 2 managers that need to
have a reminder sent to them. I have the spreadsheet set up so that the
user just needs to put a checkmark under the zone the project is for.

What I would like to do is be able to generate a reminder email that
will be send to the managers of the zones dependent upon if there is a
checkmark in the zone box.

I know how to have an email genereated, but what I don't know how to
have it address it to the managers in the zones. So for example, if
Zone Central had a checkmark, the email would automatically put the 2
email address in the TO:. If more than one zone is checked, I would
like it to address to the 4 managers responsible and so on.

Any thoughts?


--
tanyhart
------------------------------------------------------------------------
tanyhart's Profile: http://www.excelforum.com/member.php...o&userid=35148
View this thread: http://www.excelforum.com/showthread...hreadid=555082