Converting Excel addresses into word address labels

Copper Contributor

How do I convert excel spreadsheet into word address labels? I have two columns in excel spreadsheet - one is names and one is complete address. I have tried multiple times but unsuccessful.

1 Reply
Use Word's mail merge feature (on the Mailings ribbon), using the Excel file as the data source. If your Excel sheet doesn't have a title in the first row for each column, insert a row there and put in the titles (the mail merge uses these as the names of the merge fields). If you aren't familiar with Word's mail merge, see https://www.gmayor.com/merge_labels_with_word_2007.htm (it still applies to all later versions).