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.
Alert
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, orXLS. - 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/XLSXfiles, variable values for each recipient are entered in separate columns under the headings. InCSVfiles, 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.
How to prepare a file manually in Yandex Documents
- 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 File → Download as, select the
XLSXorCSVformat, and save the file on your computer.
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
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.
Was the article helpful?
Previous
Next