filtering a mailing list

[Wendy_Farkas]

I want to produce mailing labels in Word, using an Excel spreadsheet as a data source. I want to reduce the number of records by having unique values in the MAddress field; that is, I want to mail to a family (residence) rather than to individuals (e.g. spouses who reside at the same address).

So how do I filter the spreadsheet to show unique values in that one column? Do I filter in Excel or in the Mail Merge Manager?

TIA

Wendy

 

[JE McGimpsey]

I want to produce mailing labels in Word, using an Excel spreadsheet as a
data source. I want to reduce the number of records by having unique values
in the MAddress field; that is, I want to mail to a family (residence) rather
than to individuals (e.g. spouses who reside at the same address).

So how do I filter the spreadsheet to show unique values in that one column?
Do I filter in Excel or in the Mail Merge Manager?

I'd use XL's Advanced Filter capability (Data/Filter/Advanced Filter)
since you can specify "unique records only".

If you're not familiar with Advanced Filters, Deb Dalgleish has a great
introduction:

http://www.contextures.com/xladvfilter01.html