Using the event attendance report and the blank name badge stock you've purchased for your event:
In Word, click Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard to start the mail merge wizard.
Choose Labels, and then click Next: Starting document.
Choose Label options, select your label vendor and product number, and then click OK.
Click Next: Select recipients.
Click Browse, select your Excel mailing list, and then click Open.
Make sure the First row of data contains column headers box is selected and click OK.
Check your list. Drag the bottom right corner to make the dialog box bigger. Then click OK.
Click Next: Arrange your labels.
We suggest adding the HBA logo in this step
Insert merge fields (name, company, etc.) and click OK.
Click Update all labels.
Click Next: Preview your labels.
Click Next: Complete the merge.
Click Print, click OK, and click OK again.
For more information, please view this Microsoft article.
