Converting Excel addresses into word address labels

%3CLINGO-SUB%20id%3D%22lingo-sub-2018174%22%20slang%3D%22en-US%22%3EConverting%20Excel%20addresses%20into%20word%20address%20labels%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2018174%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20convert%20excel%20spreadsheet%20into%20word%20address%20labels%3F%20I%20have%20two%20columns%20in%20excel%20spreadsheet%20-%20one%20is%20names%20and%20one%20is%20complete%20address.%20I%20have%20tried%20multiple%20times%20but%20unsuccessful.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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).