Excel Emailer – VB expert needed

The project entails:

Excel Tab with a table that is created via sql query (already completed) to our database (table updates when the excel opens and at 15 min intervals)

In a new tab have a button that populates a UI

UI will take user input for the following:
-Display current rows of the table (first 5 columns)
– Allow the user to select 1 or multiple rows
– Allow the user to select an email template to be used from a list
– The email template should take details in row selected and populate the email template
– A button that will create a new email with template and data completed.

If possible have the UI take the large table data and sort it via user – info is housed in one of the columns of the dataset