It sounds as though you are trying to merge single records into a merge
letter. One easy way to do this without recourse to vba or leafing through
interminable menus is to add an ASK field and a SKIPIF field to the very
start of the merge letter. These don't print so take up no space.
If we assume that the policy number you wish to search for is in a field
called 'Number' then if you merge *all* records, the following will print
only the record that has the matching number.
{ ASK Policy "Policy Number" \o }{ SKIPIF { Mergefield Number } { REF
Policy } }
You do need to ensure that {Mergefield Number} does in fact reproduce
exactly what you enter in the ASK field or they will never match.
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
Darlene wrote:
I am trying to merg data from my excel 2003 sheet to form letters in
word. To find the record I want I put in a policy # but it won't find
the record. The # would be as such 603652. Any suggestions as to how
I can get it to find the number I want to merge