How to create mailing labels

How to create mailing labels using Internet Explorer

For a PDF version of these instructions, Click Here.

NOTE: These instructions involve running a Mailing Label report in the Report Center. Please note that printing this report onto mailing labels works for most people. However, some computer or printer settings don't allow perfect alignment. In this case, you can use the Mail Merge feature in Microsoft Word. For instructions on how to do this, see below.

1.	To create mailing labels you will need to run one of the Mailing Label reports in the Report Center. These reports are designed to run on a variety of standard Avery® label types. Please continue reading to determine which report will match with your preferred label type.

In the management system, click Tools > Report Center. Expand the Pre-created Reports folder and click on the Labels folder. You will see the different label options within this folder. Hovering over each label report will show you the compatible Avery® label type. Ex: Works with standard Avery 5160/8160 format.

5.	When you run the report, a new window will open. If a new window does not open, check any pop-up blocking software you may have installed and add secure.thriva.com to the trusted sites. You may also try holding down the CTRL or shift button and clicking on the “Run Report” button again.

7.	NOTE: The first time that you go through this process, we recommend printing only the first page of labels in order to make sure the margins are set properly and that they print as desired.

8.	On your browser, click File > Print. When you are sure all setting are correct, click "Print".

9.	NOTE: On the first page of labels, the top row of labels will be blank. Also, remember to set your page margin settings back to normal when you are done printing labels.

NOTE: These instructions are for Microsoft Word 2003. If you have a different version of Word, you can find Mail Merge instructions by clicking on Help > Microsoft Office Word Help.

1.	Create a report in the Report Center that includes the fields in which you are interested.

2.	Run the report in Comma Delimited Format to export it to Microsoft Excel

3.	Save the file to your desktop (or to a location that is easily referenceable). At this point, you may close Excel, if you’d like.

6.	On the right, a sidebar will appear. Under Select Document Type select Labels and then click Next, at the bottom.

7.	On the next screen, you may leave Select Starting Document set as Use the Current Document. Under Change Document Type select Label Options. Select the type of label to which you are printing (Avery 5150, as an example). Click OK and Next, at the bottom.

8.	On the next screen, under Select Recipients, you may leave it set to Use an existing list. Under Use an existing list, below, click Browse. Navigate to and select the file that was saved from Microsoft Excel. Once you have selected your file, at the bottom, select Next: Arrange your labels

9.	At the top of the next screen, select More Items. Insert the fields into the document in the order that you would like them to display. Once inserted, close the window.

10.	At this point, the cell in the upper left should look something like this example:

«Participant_FullName_Last_First»«Participant_Address»«Participant_City»«Participant_State»«Participant_Zip»

11.	You will want to add any additional formatting (such as line breaks, or a comma between City & State) to the upper left cell. Once you have the upper left cell formatted correctly, it should look something like this:

12.	Press Update all labels to apply your changes to all of your labels.

14.

When previewing your labels please keep in mind that if the information was not entered correctly by the registrant, or if not all of the information was included at time of registration that it will not display correctly on the label, either. If everything looks good, you may complete the process and print your labels.