Resubmit All or Upload from Excel

  • joe2037
    Asked on January 18, 2018 at 7:50 AM

    I am using the form as a petition for school funding and want to add another politician to the email workflow. I do however want them to see all of the people that have submitted already by getting all of those individual emails of people that have already filled out the form. I can disabled the current emails and only add this persons and then go in each one and resubmit but that is time consuming. In addition, the email says edited instead of just being a normal email.

    What is the best way to handle this?

    If there is nothing out of the box, is there a way to upload an excel list of petition signers and have the email workflow kickoff?

    it will be a daunting task to have each and every person file their petition again to a separate form for this other polititian.

  • Ardian_L
    Replied on January 18, 2018 at 10:01 AM

    The easiest way would be to download all the submissions as an excel file. And then use some mailing tools like MailChimp to send an email to all the emails on that file.

    Please check below on how to download the excel file from submissions:

    https://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel

  • joe2037
    Replied on January 18, 2018 at 10:12 AM

    I don’t want to reach the people that filled out the form, I want to reach the people that are receiving the petition after the user submits. It’s formatted to add their personal comments and customize an email to the politician. It also uses their email as the reply to. A mass email won’t work. 

  • David JotForm Support Manager
    Replied on January 18, 2018 at 11:32 AM

    Besides the time consuming solution(re-submitting one by one), there is no other feature to resubmit all the notifications to the new recipient. What you could do is to create a form report, such as HTML or Grid listing report, and share it with the new recipient if he needs to have access to those submissions:

    https://www.jotform.com/help/105-How-to-Create-a-Grid-Listing-Report 

    https://www.jotform.com/help/209-How-to-Create-an-HTML-Table-Listing-Report