Program Google-script and Excel VBA
$30-250 USD
Paid on delivery
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.
Project ID: #19006666
About the project
7 freelancers are bidding on average $145 for this job
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More
Hi I can do it in Google Sheets - and i have some thoughts why it is right way instead of excel a) Excel doesnt have good Event-based system. VBA is already old system and isnt good for internet processes b) Google More
Hi Sir/Mdm Thanks for reviewing my application. I am well versed in VBA having used it in various financial institutions. As I am a new freelancer, I am willing to do this job at a cheap cost or even for free. Pleas More