Mail Merge

[Darlene]

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 #

 

[Doug Robbins - Word MVP]

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