ExcelBanter - Generate letter

Good grief what is the world coming to?

A world where corporations are subject to self-regulation (that is they can
pollute and/or exploit at will), but parents of absent kids get a letter.
Talk about picking on the easy targets.

Bob

"dvya" wrote in message
...
I am using a excelsheet to track attendence at my preschool.

I have a table, the first column is a list of 200 names, the next 20
columns are all the school days of the particular month. For each school day
i have a letter code i.e. a=absent p=present. Every time a child is absent i
have to track the reason, is the child sick? did they go on vacation? etc..

What i would like to do is to have excel automatically generate a letter
that I can sent to the parents if the attendence code is "a"(absent).

In my limited knoledge of excel i figured that the best way to do this is
, to bring forward to another sheet every instance where "a" is used along
wth the childs name and date of absence, and then run a mail merge on this
sheet.

Is this the best way?

What formula would i use to do this?

Thank You.