When script runs it importing excel sheet from its folder .
excel has 2 Columns :
Column 1: Names
Column 2: E-mails
Second step :
A window is popping up with 3 elements :
1. Name (Text filed) : When user starts typing a name it showing a drop down menu and it autocomplete while typing the name - It takes the list from the excel sheet (Column 1 --> Names).
2. Email (Text filed): After choosing a name it will automatically complete the Email that relates to that name in Column B. - if there is no email there it leaves the field empty so the user can fill in the Email himself
3. "Send" button : When user click "Send" it sends an email to the address from section 2.
Text of the email : "You got a new package"
If email was sent successfully : show an alert "Email sent"
If it failed : show an alert "failed"
You need to support both sending through outlook and through gmail account. so you will need to make 2 functions for sending through outlook and through gmail.
Permission for the emails can be written hard coded.