Instead of sending individiual emails this guide will show you how to group data belonging to the same recipient and send them a single email with a table containing all the information.
Step 1. Make sure the "To" column in your spreadsheet is identical for all rows you want to group.
Añade una columna a tu hoja de cálculo llamada "Archivos adjuntos". Añade los nombres de los archivos en la celda correspondiente a cada destinatario. Puedes añadir varios archivos separándolos con punto y coma.
![Spreadsheet containing 6 rows split into 3 recipients showing the identical To column.](/knowledge/many-to-one-spreadsheet.png)
Step 2. Start a mail merge and upload your spreadsheet
![Select 'Use spreadsheet' from the plugin menu](/knowledge/many-to-one-use-spreadsheet.png)
Assuming you have installed SecureMailMerge and started the plugin from the Apps menu, you will see the following screen. Click the "Upload Spreadsheet" button and the select your spreadsheet file from your hard disk.
Step 3. Activate "many-to-one" mode
![Añadir archivos desde el disco duro](/knowledge/many-to-one-table-wizard.png)
If there are multiple rows in your spreadsheet with the same email recipient then a message will appear asking you if you would like to send a traditional mail merge or a many-to-one mail merge.
In traditional mail merge mode, each row will be sent as a separate email. In many-to-one mode, all rows with the same email recipient will be grouped together and sent as a single email.
Switch to many-to-one mode and a button will appear further down that let's you add a table to your mail merge.
![Añadir archivos desde el disco duro](/knowledge/many-to-one-insert-token.png)
If you instead just insert a regular personalization token (in many-to-one mode) instead of a many-to-one table, then values from all rows will be inserted as one long text seperated by commas.
![Different approaches to inserting tokens in many-to-one mode.](/knowledge/many-to-one-different-tokens.png)
Step 4. Send a test email and then send the campaign
You can then proceed by sending a test email, to check your personalization tokens are working as expected.
Note that the first row of the spreadsheet will be used for the test email, so you will only see the many-to-one features if that recipient has multiple rows assigned.
When you're happy, you can send the campaign to all recipients.
→ Haga clic aquí para obtener más ayuda sobre otros casos de uso (por ejemplo, CC/CCO múltiples, archivos adjuntos personalizados, etc.).