Exporting Excel into Word to print Labels

[Pam]

I am using Microsoft Office 2000 and would like to print
off address labels for mailings. We use a program
designed for a Mortgage Company and I can create a report
with all borrower information then export into Excel.

My question is how to I eliminate duplicate lines in Excel
and print mailing labels?

Thanks in advance,
Pam

 

[Gord Dibben]

Pam

For help on Word mail merge using Excel as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm

To eliminate duplicates you could first use Data>Filter>Advanced Filter and
check "unique records only".

For more on filtering see Debra Dalgleish's site......

http://www.contextures.on.ca/xladvfilter01.html#FilterUR

Gord Dibben Excel MVP