- Generate the Personal Profile Export Report (in Volunteer Impact)
- Go to: Reports, then click on “Personal Profile Raw Data” found in the sidebar under General Reports
- Search for the desired profiles.
- Select the fields you need for your badges in Basic Export Columns:
- Name Fields: “First Name”, “Last Name”, etc.
- Mics Fields: “PhotoCodeUrl”
- In the “Other Settings”, select either XLSX or XLS as the file format
- Click the [Export Profiles] button
- Create Badge / Nametag Template (in Microsoft Word)
Before beginning the Mail Merge operation, open Microsoft Word to create or modify the template you wish to use. You can take advantage of Microsoft Word’s list of labels, badges and nametag templates available. Here are a couple templates you can work with in preparing your badges:
- Mail Merge (in Microsoft Word)
- Save your badge template file as a Word document (.DOC or .DOCX)
- Select the “Mailings” tab in the ribbon
![](https://www.betterimpact.com/wp-content/uploads/sites/19/2020/12/image-25.jpeg)
- Click on Select Recipients >> Use an Existing List.
![](https://www.betterimpact.com/wp-content/uploads/sites/19/2020/12/image-26.jpeg)
- Locate the Personal Profile raw data report you generated and click “Open”.
![](https://www.betterimpact.com/wp-content/uploads/sites/19/2020/12/image-27.jpeg)
- A pop-up window may be displayed. Click “Yes” to trust the source.
![](https://www.betterimpact.com/wp-content/uploads/sites/19/2020/12/image-41.png)
- Another pop-up window may be displayed. Leave everything as is and click “Ok”.
![](https://www.betterimpact.com/wp-content/uploads/sites/19/2020/12/image-42.png)
- To set the maximum height and width dimensions of the images inside each badge, insert a “1×1” table. Click on your table and drag to set the desired size.
![](https://www.betterimpact.com/wp-content/uploads/sites/19/2020/12/image-28.jpeg)
*IF YOU ARE UNABLE TO SELECT YOUR TABLE:
Right click on the badge template and select “More Layout Options” (“Format AutoShape” on a PC).
![](https://www.betterimpact.com/wp-content/uploads/sites/19/2020/12/image-29.jpeg)
Click on the “Text Wrapping” tab (“Layout” tab on a PC), and click “Behind text”, and then click “Ok”.
![](https://www.betterimpact.com/wp-content/uploads/sites/19/2020/12/image-30.jpeg)
Click on your table and drag to set the desired size.
![](https://www.betterimpact.com/wp-content/uploads/sites/19/2020/12/image-31.jpeg)
- Set your cursor in the table you created and press:
- Control F9 on a PC OR
- Command F9 on a Mac (if standard function keys are enabled) OR
- Command + fn F9 on a Mac (if standard function keys are NOT enabled)
![](https://www.betterimpact.com/wp-content/uploads/sites/19/2020/12/image-32.jpeg)
- Type “includepicture” followed by a space.
![](https://www.betterimpact.com/wp-content/uploads/sites/19/2020/12/image-33.jpeg)
- Press:
- Control F9 on a PC OR
- Command F9 on a Mac (if standard function keys are enabled) OR
- Command + fn F9 on a Mac (if standard function keys are NOT enabled)
- Type “photourl”
![](https://www.betterimpact.com/wp-content/uploads/sites/19/2020/12/image-45.png)
- For all other merge fields, simply place your cursor in the location you want the field data to appear, select “Insert Merge Field” (from the Mailings menu) >> FirstName (for example) to insert the merge field
![](https://www.betterimpact.com/wp-content/uploads/sites/19/2020/12/image-34.jpeg)
![](https://www.betterimpact.com/wp-content/uploads/sites/19/2020/12/image-46.png)
- When you are satisfied with the placement of your merge fields, go to the ‘Mailings’ tab, select “Finish & Merge”, and “Edit Individual Documents” to view your mail merge prior to printing, leave the selection as “All” and click “Ok”.
![](https://www.betterimpact.com/wp-content/uploads/sites/19/2020/12/image-35.jpeg)
- When you generate your merge document, you may notice that some of the merge fields, including the photo have not been updated and do not display the data, or you may see an error message. To fix this, highlight the entire document (Shortcut is CTRL + A), and press F9 (or fn F9). This will update all your fields.
![](https://www.betterimpact.com/wp-content/uploads/sites/19/2020/12/image-43.png)
![](https://www.betterimpact.com/wp-content/uploads/sites/19/2020/12/image-44.png)
*NOTE: The individual photos may not display in your document. You may need to go to the Print Preview or print the document.