The result of this project is 3 texts. The texts are:
1. Google-script: We have registered a Google Form. If someone fill in this form we want an e-mail sent to us with the e-mail-address they entered in one of the google-fields. You do not need my Google-form. Create your own with a text-field for the e-mail and a button and make sure the script sends that e-mail to a fixed e-mail-address.
2. Excel-VBA: Again - I only want the code - I will install it and tweak it myself. The program should fetch the Google Forms data and put it in Excel. The data to be fetched is filtered by the e-mail the user of the Google-form has given. In your code you can just create a test-sub where you manually set the e-mail-address just to show it works. I will tweak it to work with my sheet and pick the e-mail from where I want.
3. Excel-VBA: 2 sheets in the workbook should be sent as PDF on e-mail to that E-mail address. We will format the sheets with content from the google-forms and respond by sending the e-mail back to the Google-forms-user.
Summary:All in all we have Google Forms (but you do not need mine) and we have an Excel-sheet (but you do not need mine). What we need is to get an e-mail when someone fill inn the form and from Excel to be able to fetch that data and send the result as PDF to the e-mail-address.