I have a mailing that needs to go out and am not very good with Mail Merge in Word 2013. I have an excel sheet with 4 columns, name, address, city and customer number. I have labels that are 2 across, 10 down. I would like to have the left label contain the name, address and city and then the right label across to contain the customer number. Is this possible? Thanks.
What Brand are the labels? Does anything on the box have a label number? Word has a built-in wizard that is easy to use as long as you get the right label layout. Click Start Mail Merge (on the MAILINGS ribbon) to pick the kind of labels you have or create a custom label.
You can pick the source of the labels to be your Excel spreadsheet. To identify that the data will come from your Excel spreadsheet, Choose Select Recipients and then Use existing list, browse to the Excel workbook, and identify the data as questions are asked
Then you will be ready to lay out your label. Click Insert Merge Field (also on the MAILINGS ribbon) whenever you want information from your list.