asked on
Splitting Labels in Word
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.
Microsoft Word
Last Comment
itgolfer
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks, I ended up just doing the 1 x 10 and set a tab to insert the field on the right label. 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.