How to Create Seller Mailing Labels for Auction Settlements in BidWrangler

Using your BidWrangler seller information, you can create mailing labels for your seller settlement checks in just a few minutes with help from external resources. Export your settlement data from the BidWrangler Admin Portal as a CSV file, then merge that file into a label template using Microsoft Word (Mail Merge) or the free Avery Design & Print Online tool. This guide walks you through each step.

Sending settlement checks to your sellers is faster when you can print addressed mailing labels in bulk. Although BidWrangler doesn't print labels directly, it does let you export the exact seller information you need. This article covers how to:

• Export seller name and address data from BidWrangler as a CSV file

• Create and print labels using Microsoft Word's Mail Merge feature

• Create and print labels using Avery Design & Print Online

Before you can print labels, export your seller data from the BidWrangler Admin Portal. This CSV file becomes the data source for your labels.

1. In the Admin Portal, navigate to Settlements.

2. Apply the appropriate filters for the specific auction or Auction Group you're mailing checks for.

3. Click the Filtered Items button.

4. Select Export Settlements.

5. Choose the fields to include in your export — typically the seller's name, address, city, state, and ZIP code.

BidWrangler generates a CSV spreadsheet containing all the seller information for that auction. Save the file somewhere easy to find, since you'll use it as your data source in the steps below.

Once you have your exported CSV file, you can use Microsoft Word's Mail Merge feature to generate your labels.

1. Open Microsoft Word and go to Mailings > Labels > Options.

2. Select the label type you're using (for example, Avery 5160 or 8160).

3. Use the Mail Merge tool to connect your exported BidWrangler CSV file as the data source.

4. Insert the appropriate merge fields (name, address, city, state, and ZIP) into the label template.

5. Load your label sheets and print.

If you prefer a web-based tool, Avery offers a free online platform that merges your BidWrangler CSV data onto its label templates.

1. Go to avery.com/templates and type your label's 4- or 5-digit product number into the search box.

2. Click the red Start Designing button, then sign in or create a free Avery account.

3. Choose a blank or pre-designed template and click Customize Design.

4. To add your seller data, use the Import Data / Mail Merge feature to upload your BidWrangler CSV spreadsheet.

5. Format your text by highlighting it and adjusting the font size, color, and alignment as needed.

6. When your design is ready, click Preview & Print at the top of the screen.

7. Click Get PDF to Print to download or open your finished labels as a PDF.

Microsoft Word and Avery Design & Print Online are just two examples — they aren't your only options. Because your BidWrangler export is a standard CSV file, you can format the raw seller data into printable mailing labels using virtually any spreadsheet, word processing, or label-design program that supports importing data or mail merge. Feel free to use whichever tool best fits your workflow; the steps above are simply two reliable, widely available approaches.

At a minimum, include the seller's name, address, city, state, and ZIP code. These are the fields you'll map to merge fields when building your labels. You can include additional fields in the export if they're useful for your records, but only the address fields are needed to print mailing labels.

Yes. If it fits your mailing process better, use the Microsoft Word Mail Merge feature to print seller addresses directly onto envelopes rather than onto standard label sheets.

When you open the downloaded PDF to print, check your computer's print dialog settings first. Make sure Scale is set to 100% or that Actual Size is selected. Avery also recommends choosing a "Best Quality" print setting and setting your paper type to "Labels" or "Heavyweight" to prevent the printer from slipping. If the problem continues, review your printer manufacturer's recommended settings.

Have questions about exporting your settlement data for mailing labels? Contact the BidWrangler support team at helpdesk@bidwrangler.com.