That's a lot of extra work. You can make your mailmerge conditional upon
the value of a field in XL.

in Word's Data Merge Manager, click the Query Options/Filter Records
tab. Select your field and choose "is equal to" from the Comparison
dropdown, and enter "a" in the Compare To textbox.




In article ,
"dvya" wrote:

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?

dyva

John Walkenbach has a downloadable workbook demo of how to create a Mail Merge
strictly using Excel if you don't want to use Word.

http://www.j-walk.com/ss/excel/tips/tip92.htm

I would use Word myself, but your needs may differ.

Gord Dibben Excel MVP

On Fri, 05 Mar 2004 09:10:52 -0700, JE McGimpsey wrote:

That's a lot of extra work. You can make your mailmerge conditional upon
the value of a field in XL.

in Word's Data Merge Manager, click the Query Options/Filter Records
tab. Select your field and choose "is equal to" from the Comparison
dropdown, and enter "a" in the Compare To textbox.




In article ,
"dvya" wrote:

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?