Word's Mail Merge Partner Name Tags

Ms. Sapper, this year's annual partner meeting coordinator for a global accounting firm, faced an interesting challenge. She wanted to provide the 400 partners attending the meeting the opportunity to mix, mingle, and network. Most partners only knew a handful of their peers, and Ms. Sapper wanted to make everyone feel as comfortable as possible. With a list of partners in hand, she decided to prepare name tags for each participant. Each tag would include the partner's first name, last name, practice area, and region. Arranging the tags alphabetically by last name at the event's welcome desk would allow each partner to quickly find and use his or her name tag. Complete the following steps to prepare partner name badges.

a. Download and save "partners.xls" from the MIS 10e OLC.

b. Use Microsoft Word's mail merge feature to generate name tags sorted by last name and then first name. Use a suitable name tag template, and format the name tag as illustrated below. Be sure to include first name, last name, industry, and region. Turn in either the first two pages of the merged names or the merged file, depending on your professor's preference.