This article discusses how to create address labels from the Query Tool using Excel and Mail Merge in Word.


Required Access:

You will need Query Administrator or Administrator access level. 


Where to go:

  1. From the Member Portal homepage, go to Admin > Member Management.
  2. Find the Query Tool
  3. Select the Query Tool:   Member Roster - Current
  4. Click on the Excel button to export your file 
  5. Download and open your file.
  6. Delete the columns you don't need and keep the following:
    • Last_name
    • First_name
    • Address
    • City
    • State
    • Postal code
  7. Rearrange the Excel sheet so that the first_name column appears first and save your file to a location like your Desktop.


Then, follow the steps in this video to do a Mail Merge in Word:

https://support.microsoft.com/en-us/office/print-labels-for-your-mailing-list-276a2cd1-74d2-43d0-ab5a-b90460358ad5



Deleting and Rearranging Columns in the Query Tool (Optional)

  1. As an alternative, in Step 4 of the directions above, you can stay in the Query Tool to delete and rearrange the columns before exporting it to Excel. Take note, these steps takes longer and we recommend you use Excel.
  2. Click on the X icon next to the label of the column names to delete the columns you don't need. You will need to delete these columns one by one.

  3. Once you have kept all the columns you need, you can rearrange the Last_name and First_name by clicking on Move Columns.
  4. This will take you a page where you can click and drag the columns to change the display or sort order. Click on the First Name label and drag it up to the first row.
  5. Click Save.
  6. The columns will appear in order and you can click Excel to export your report.