Forum Discussion

Mike_Navolio's avatar
Mike_Navolio
Copper Contributor
Dec 28, 2020

Converting Excel addresses into word address labels

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.

  • Jay Freedman's avatar
    Jay Freedman
    Brass Contributor
    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).

Resources