Export list from Excel into Word to make labels

  • Thread starter Thread starter terryspencer2003
  • Start date Start date
T

terryspencer2003

I have to make some name tags in Word. The list of names is in Excel.
Is it possible to export the list from excel to word into labels for
printing? The names are in their own cells and look like this in
Excel:

"Bob Smith Table 9"

I would like them to show up like this in Word:

Bob Smith
Table 9

So I need a carriage return after the name, and then the combined text
put into a label so that I can print them and then cut them into tags.

Is this possible?

Thanks

RK
 
Use the Mail Merge Wizard in Word to create the labels:

In Step 1, choose to create Mailing Labels
In Step 2, choose your Excel file as the data source.
In Step 3, merge to a new document.

In the merged document, choose Edit>Replace
Find what: Table
Replace with: ^pTable

This will move the Table information to a new line, and you can then
print the merged document.
 
Back
Top