Repeated Use

[DUNNER7]

I am an Assistant Principal of a High School and we have a form letter that
is used each day for students who do not attend detention. I have downloaded
demographic information from our Student Information Database into an Excel
worksheet. My problem or question is this...Is there a simple way to use the
form letter each day and select the recipients from the excel worksheet using
the mail merge tool? Let me make it a bit clearer, If the letter is used
each day, but different recipients recieve the letter each day does the whole
mail merge process have to be started from scratch or is there some type of
shortcut to the process. I know how to do it, but different people are
assigned each day to print the letters.
Thanks for any help
Del Dobbs

 

[Graham Mayor]

Given that we don't know what information you store in Excel, it is
difficult to be specific, but a SKIPIF field might work
For example, let's say you have the incidents logged by date in a column
called MyDate, and you want to send letters only to those people recorded
for the current date, then start the merge letter with
{SKIPIF {Mergefield MyDate \@ "yyyyMMdd" } < {DATE \@ "yyyyMMdd"} }
Then as DATE is always today's date, you only get letters for today's
miscreants. It is simple enough to add a calculation to the comparison if
you want (say) yesterday's offenders thus
{SKIPIF {Mergefield MyDate \@ "yyyyMMdd" } <> {={DATE \@ "yyyyMMdd"}-1 } }

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>