Latest Lists

How do I alphabetize mailing lists in Excel and then get them on a mailing label?

I have a mailing list of 300 names and addresses for my small business. i need to be able to alphabetize this list and then export them to a mailing label for our newsletter. I have used word 2003 and mail merge but it didn't alphabetize or notify me of duplicates. Thank you.

Public Comments

1. If your Excel data has one row per record then you can select all your data and then sort on any column that you want to with sub sorts too. Pick a column that should have unique entries for each record. Insert a column beside it, then enter a formula like this modified to suit your data. =IF(COUNTIF($A$1:$A$300,A1)>1,"DUP","") Copy down the length of your data. This says to look at the column A from A1 to A300 and find A1. If the count of A1's is greater than 1, return DUP and if the count isn't greater than 1 return nothing. Delete your duplicate records, sort and do the mail merge. If the column of unique entries is already sorted in order this formula will work when entered into a helper column beside it. =IF(A2=A1,"DUP","") Copy down the length of your data.