There is a list of drop-down buttons in my MS Form:
Drilling
Module
Tracking
....
There are about 6 departments.
If a user chooses Drilling, an e-mail is sent to the e-mail address of that person email who does drilling (so no multiple addresses)
If a user chooses Module, an e-mail is sent to the e-mail address of that person email who does module task.
Etc...
The code is not working.
I was not sure where to enter email id's. can you guide me where to enter and send me the screen shots
Hi @gunti ,
If that's the case, where is the email address of your drilling department?
If you have manually entered the e-mail address of the drilling department, please refer to @v-bofeng-msft reply.
Best Regards,
Sunshine Gu
what if I am submitting the form. If I choose drilling in MS Form. then the email should be sent to that particular drilling department.
The email address is automatically getting updated in excel sheet to whoever I am sending the link to submit the MS form response
Hi @gunti ,
If your email column is auto-populated, you can simply use Responders' Email to send emails to specific submitters
Please check this test:
Best Regards,
Sunshine Gu
yes it is automatically generating the time when filled
yes it was automatically get filled when someone fills a form
Hi @gunti ,
Is your Email column in excel table filled in by Responders' Email?
Like this:
Best Regards,
Sunshine Gu
Hi @gunti ,
Is your Completion time column in excel table filled in as MS Form Submission time?
Best Regards,
Sunshine Gu