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[ at ]discussions.microsoft.com> wrote in message
news:0D93E405-B7EF-417A-A3DA-7A83F8A7F0BD[ at ]microsoft.com...
[Quoted Text] >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 #
>
>
|