Check mailing list
check_mailing_listUse this when the user wants to check or clean a mailing list or contact list before printing labels ("turn my contact list into mailing labels", "address labels from excel spreadsheet", "clean up my address list"): reads an uploaded CSV/XLSX file or a typed list, shows which columns were used for name, street, city, state and ZIP, formats each address the USPS way, and reports missing streets, cities, states, ZIP codes, unknown state codes and duplicates, with a cleaned CSV download. Does not verify that an address exists, does not look up ZIP+4, and does not print the labels (use generate_label_sheet).
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "check_mailing_list"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | No | Optional uploaded mailing list: a CSV, TSV or Excel .xlsx file with one row per label, e.g. contacts.csv or Christmas list.xlsx. Name, address, city, state and ZIP columns are detected from the headings (Google Contacts, Outlook, Etsy and Shopify exports work). | |
| kind | No | What the labels are for: address (mailing labels, default), return_address, shipping, name_badge, place_card, file_folder or general text. Sets the default sheet and text style. | |
| sort | No | Order of the labels: none (list order, default), zip, name or last_name. | |
| sheet | No | Excel sheet name to read, e.g. Guests. Default: the first sheet with data. | |
| labels | No | The typed or pasted list, one item per label. Either address objects, e.g. [{"name":"Jane Smith","address1":"123 Main St","address2":"Apt 4B","city":"Springfield","state":"IL","zip":"62704"}], or plain text labels with lines separated by \n, e.g. ["Jane Smith\n123 Main St\nSpringfield, IL 62704"]. For name badges use {"name":"Ana Lopez","title":"Engineer","company":"Acme"}. | |
| columns | No | Optional column mapping when the headings are unusual: heading text or column letter per field, e.g. {"name":"Guest","address1":"Mailing Street","zip":"F"}. | |
| uppercase | No | USPS style: all capitals without periods or commas (e.g. SPRINGFIELD IL 62704). Default false. | |
| has_header | No | Whether the file's first row is column headings. Default: detected (headings like Name, Address, ZIP or a first row without numbers). | |
| include_country | No | Also print USA on US addresses that have a country. Default false (non-US countries always print). | |
| remove_duplicates | No | Print identical labels only once. Default false (duplicates are counted and reported). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| notes | Yes | ||
| issues | Yes | ||
| source | Yes | ||
| preview | Yes | ||
| records | Yes | ||
| ok_count | Yes | ||
| downloads | Yes | ||
| file_name | Yes | ||
| duplicates | Yes | ||
| columns_used | Yes | ||
| issues_count | Yes | ||
| problem_counts | Yes |