Thursday, October 18, 2012

How to Do Name Badges With Microsoft Excel


1. Launch Excel. A blank spreadsheet will appear.
2. Populate a column with names. If you want to include titles on the badge, populate a second column with this information. Click 'File' and select 'Save.' Give your list a name, and click 'OK.'
3. Launch Microsoft Word.
4. Click 'Tools.' Point to 'Letters and Mailings,' and click on 'Mail Merge Wizard.'
5. Click 'Labels.' Select 'Label options.' Select your name badge size.
6. Click 'Use an existing list' under 'Select recipients.' Click 'Browse.' Select the Excel file with your name badge information. Click 'Open.'
7. Click your Excel list in the 'Select Table' dialog box. Click 'OK.' Click 'File' and select 'Print.'
8. Peel off the printed labels from the label paper and stick them onto the name tag holders.

Blogger news