Recipient lists
You can set up a few recipient lists for your company. This way, you won't need to upload one every time you create a mail-out. All employees can see and edit the recipient lists.
Restriction. You can upload no more than 100 lists for one company.
Create
- On the left panel in Send, select Recipient lists.
- Click Add list.
- Click Select file and attach the prepared file.
File requirements
- Format: CSV, XLSX, or XLS.
- Maximum 100,000 rows in the file.
- Each row in the file must contain the data for one recipient.
- Each row must contain an email address.
- We recommend that you add headings in the first row so you can later use them as variables in the email text. In XLS/XLSX files, variable values for each recipient are entered in separate columns under the headings. In CSV files, the values are listed in a row, separated by commas, following the order of the headings.
- No empty fields are allowed in the spreadsheet.
- Column values must match the headings.
Tip. If you try to upload a large file over a slow internet connection, the upload will fail. Check your internet connection speed on yandex.com/internet/en, make the recipient list shorter, or remove unnecessary variables from the file. Then try uploading the file again.
- Go to Yandex Documents.
- Click Create, select Spreadsheet, and enter the file name.
- In the first row of the spreadsheet, add headings for additional recipient details — one heading for each column. You can later use these headings as variables. The spreadsheet must contain a column with the recipients' email addresses.
- Fill out the spreadsheet in accordance with the headings from the first row. Allocate a separate row for each recipient. No empty fields are allowed in the spreadsheet. Examples of recipient list files show what a spreadsheet with recipient details can look like.
- Click XLSX or CSV format, and save the file on your computer., select the
How to prepare a file manually in Yandex Documents
Examples of recipient list files
- XLS or XLSX
-
email name company promo_code ivan@example.com Ivan “Alpha” Ltd 9X6O0557 paul@example.com Paul “Gamma” Ltd AE2HBP0X dan@example.com Daniel “Omega” Ltd F6AQDEVR email name company promo_code ivan@example.com Ivan “Alpha” Ltd 9X6O0557 paul@example.com Paul “Gamma” Ltd AE2HBP0X dan@example.com Daniel “Omega” Ltd F6AQDEVR - CSV
-
email,name,company,promo_code ivan@example.com,Ivan,Alpha Ltd,9X6O0557 paul@example.com,Paul,Gamma Ltd,AE2HBP0X dan@example.com,Daniel,Omega Ltd,F6AQDEVR
Rename or delete
- To rename a recipient list, click Rename. The name should be unique.
- To delete a recipient list, click the
icon and confirm deletion.