I have a Word form, using an Excel database, where I am
listing people who's been with us for five years.
I set up a table with two columns:
Column A
{ IF {MERGEFIELD Anniv} = 5 "{ MERGEFIELD First_Name }
{MERGEFIELD Middle_Initial } {MERGEFIELD Last_Name }" "" }
Column B
{ NEXT }{ IF {MERGEFIELD Anniv} = 5 "{ MERGEFIELD
First_Name } {MERGEFIELD Middle_Initial } {MERGEFIELD
Last_Name }" "" }
Next rows/cells As and Bs should enter next qualifying
records from spreadsheet IF there are any more, otherwise
to END the table at last qualifying record:
How can I set up that table to insert AS MANY CELLS/ROWS
as THERE ARE QUALIFYING RECORDS, and print closing
text "Please send us appropriate appraisals for above
mentioned individuals"
right afterwards?
Peter Jamieson - 23 Jul 2004 11:00 GMT
Mailmerge is probably going to get in your way on this one, unless you
simplify the process a bit. e.g.:
a. create the letter as a non-mail merge document
b. set up a separate mail merge main document as a single table row (and
nothing else except the final paragraph mark, which you can't remove) with
Column A
{ MERGEFIELD First_Name } {MERGEFIELD Middle_Initial } {MERGEFIELD
Last_Name }
Column B
{ NEXT }{ MERGEFIELD First_Name } {MERGEFIELD Middle_Initial } {MERGEFIELD
Last_Name }
and use the Select recipients dialog box (or Merge Options, depending on the
version of Word) to specify Anniv = 5.
c. do the merge to an output document
d. use Edit Copy/Paste (or save the output document and use Insert|File) to
insert the output into the document you created in (a).
Or you could consider creating the Excel sheet you need and copying/pasting
it directly into the document you created in (a).
If you are producing one document for each of a number of recipients
automating that approach would probably be the simplest way to do this,
although there are alternatives.

Signature
Peter Jamieson
> I have a Word form, using an Excel database, where I am
> listing people who's been with us for five years.
[quoted text clipped - 17 lines]
> mentioned individuals"
> right afterwards?