Mail Merge specific cells from excel program

  • Thread starter Thread starter ugamike729
  • Start date Start date
U

ugamike729

To Whom can assist,
Using windows 98 or 2000, I have a MS Word document that I can merg
fields from an excel program to send to 150 people. But, I want t
send specific letters to 20 people in the field. Is their a way t
highlight who I want to send a certain letter to with out the whol
list. Are the options of sorting or filtering the fields the way t
go?
Thanks for any help,
Mik
 
You can do this by making use of the filtering facility. Add a column to
the datasource into which you add data that is unique to the 20 people to
whom you want to send the letter and then filter on that column for that
unique piece of data.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
 
SO I have a field in 98 excel that I want to select specific cells.
Highlighing is not an option for mail merging, so I have to creat
another field that will have a likeness to the cells I want to select.
So I create this new field and put in the cells of this field "new" o
the same horizontal line of the other cells. How do I relate the tw
to each other with the filtering dialogue box?
The dialogue boxes options are the problem for me. Maybe I am no
setting up the connection field either?
Thanks for your time,
M
 
In the first row of the column in which you enter the word "new" you will
have to insert a name that can be used as a mergefield. Then you select
this field in the filtering dialog box and specify "new" as the the
condition to be met.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
 
Thanks Doug.
So, I add "new" parallel to the the cells I want to select in anothe
field/column(last name), and I call that field/column(say earl
members) with the "new's" in it a name(early members) that I wil
select in the first box of the filtering dialogue. Then I make th
second box choice "equal to" and compare it to the "new's" in my newl
created field/column(early members).
Once I select "early members", the and/or box higlights and I must pu
in a another field. Is that the field/column I want to select th
specific cells from. At little confusing, and I love XP cause it wa
so easy to do this.
Thanks for the replies.
Mike C
 
Back
Top