Excel - Word Mail Merge

  • Thread starter Thread starter Maureen Smith
  • Start date Start date
M

Maureen Smith

I'm working with an Excel file, a statewide address list. I've been asked to
generate mailing labels, but of course not to everyone on the list. The
"list maker" has hidden the rows of addresses he does not want the mailing
to go to. When I do a mail merge in Word, I get blank labels for what I'm
assuming are
the hidden rows. The addresses are not all in adjacent rows.

Is this doable without a lot of dancing around? I'm using Word and Excel
2000.

Thanks.
 
Assuming there is some principle on which the addresses are being omitted,
it would be better to use filters in Word rather than hide the rows in
Excel.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
There is, I guess - it's not contained in the data at all; it was more along
the lines of "these people in this area are members of this organization;
these people are not; I want the mailing to go to the people who are not."

The filters of which you speak - is the the query option that comes up when
one is doing the merge?
 
Yes, the query options would allow you to filter the data. If you added a
field for member/nonmember, you could certainly filter on that. In Word 2002
and above, if the list is not huge, you can use the Mail Merge Recipients
dialog to select exactly those records you want included in the merge (or
select them all and deselect some).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
Back
Top