-
Grégory SelembaAsked on October 9, 2024 at 1:44 PM
Bonjour,
Est-il possible d'importer un tableau Excel et d'utiliser certaines informations qu'il contient. Notamment des adresses mail, pour un envoi automatique de mail de confirmation ?
-
Sidharth JotForm SupportReplied on October 9, 2024 at 2:58 PM
Hi Grégory,
Thanks for reaching out to Jotform Support. Our French Support agents are busy helping other Jotform users right now, so I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in French, let us know and we can have them do that. But, it might take a while until they're available again.
Now, coming back to your question, you can import data from an Excel file to a Jotform table and then add a Send Email button to send a confirmation email. Let me show you how:
Let us first see how to import data from Excel.
1. Go to your My Tables page, and click on Create Table on the top-left side of the page.
2. In the window that opens up, click on Import Data.
3. Click on Upload File and select your file or simply drag and drop your file.
4. Click on the Downward Arrow icon in the Choose Tabs To Import section, and toggle On the Set The First Row As Column Headers option.
5. Click on the Short Text option to change your column types.
6. Untick the tabs you don't want to import, and then click on Import Data.
Now, let us add a Send Email button to send the confirmation email.
1. In Jotform Tables, click on the Add button at the end of the rows, and go to the Buttons tab.
2. Now, select Send Email, enter the name, and click on the Next button.
3. Select the Notification or Autoresponder, and click on the Next button.
4. Add the Email Content, and then in the Recipient Tab, select the Email column in the Recipient email.
5. Click on the Save button, and then click on the Create Column button.
Now, when you click the Send Email button, an email that includes the submission information will be sent to the email address. We also have a guide to help you learn How to Import Data in Jotform Tables guide and How to Send Email With Form Data in Jotform Tables.
Give it a try and let us know if you have any other questions.