Out Of This World Create Name Tags In Word From Excel
On the Tools menu click AutoCorrect Options and then click the Smart Tags tab.
Create name tags in word from excel. But this is quite tedious technical task and result in Name tags which are often plain and look unprofessional like below. If you dont see your product number select New Label and configure a custom label. For example you need to use first box of each row to enter First Name and second box for Last Name.
Note In Microsoft Office Word 2007 click the Microsoft Office Button click Word Options click Proofing and then click AutoCorrect Options. After purchasing labels whose dimensions resemble those of nametags you can let Word use your Excel data to create nametags automatically. Choose the brand and product number.
Use headings that are easily recognisable as this will make things easier for you when you do the merge. The paper we use is A4 has top and bottom margins of 12 mm and side margins of 15 mm. Click Labels from the Create group on the Mailings tab.
Click the Formulas tab and click Define Name in the Defined Names group. So here you go a step by step guide to using mail merge in word to create name badges. Select Options and then Label Options Select your printer the vendor for the name tags you are using and the corresponding product number for the labels.
Select or clear the Label text with Smart Tags check box. Enter a name for the list such as Nametags and click OK 14 Save the workbook and close ExcelPerforming the Merge. How to create custom name tags with Word and a mail merge from Excel For events we print 54 mm x 90 mm name tags.
For creating an excellent name tag in Word go to the Mailings tab. Then click Smart Tags in the AutoCorrect dialog box. Select the label type and size in Options.