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 (it still applies to all later versions).