VB script sending mail

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.