Mail Merge

I am merging information from an excel sheet to word. The first column is an
assigned # (******) to a client. When doing a form letter I click find and
would like to just put in the assigned # to that client's name and address,
etc. comes into the merge document. I find when i click find and type in the
# it will not bring up the information, but if when I click find and type in
part of the client's name it will bring it up. Is there a way to bring up
the information by the client's #

Are you preparing letters to multiple clients at the one time (which is the
real purpose of mail merge) or just preparing one letter at a time and
wanting to use the data from the spreadsheet for that purpose.

If the latter, it would be better to use a userform

See the following pages of fellow MVP Greg Maxey's web site:

http://gregmaxey.mvps.org/Create_and_employ_a_UserForm.htm

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm

On the page that comes up with the second of the above links, you will find
information on how to populate a list box or comboboxwith information from
Excel.


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Darlene" <Darlene DeleteThis @discussions.microsoft.com> wrote in message
news:0D93E405-B7EF-417A-A3DA-7A83F8A7F0BD@microsoft.com...
>I am merging information from an excel sheet to word. The first column is
>an
> assigned # (******) to a client. When doing a form letter I click find
> and
> would like to just put in the assigned # to that client's name and
> address,
> etc. comes into the merge document. I find when i click find and type in
> the
> # it will not bring up the information, but if when I click find and type
> in
> part of the client's name it will bring it up. Is there a way to bring up
> the information by the client's #
>
>