Combining records for merge to Word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a data list of names and addresses in an excel worksheet. Each row of
the worksheet contains the name, address, city, state, zip of an individual.
There may be multiple individuals with the same address. I would like to
merge and mail only one letter. For example to the Smith Family as opposed
to two letters, one to Sam Smith and one to Sally Smith. How do I accomplish
this?
 
you must have the headings e..name and address
clik data(menu)-filter-advancefilter
in the advance filter window
against >list range> give the column of addresses only (click the window
on right end and highlight the column of address including the ehding)
leave blank creiteria range
check <unique records only>
check <copy to another location> at the top
then <copy to> you give one cell name outside your database and clik ok.
 
Back
Top