Question from one of our superhero customers: How do you handle your name badges for larger group events? I’ve learned we use Excel and mail merge into Word, but it takes me 2 hours to format and adjust, then re-adjust, then I have to manually copy and paste the logo onto the label, which takes more time to format because it then messes up the formatting I’ve just done. There has to be a smarter way. Any ideas?
RedCape Answer: If your list of attendees is stored in Excel, you can use the mail merge feature in Word 2010 to quickly and easily create name tags. The trick is to set up one name tag the way you want it and use the “Update Labels” command to create the remaining labels.
Check out the video here: