Hi,
I am Nallakumar. I have more than 11 years of experience in Office AddIns and Automation.
I am suggesting the following solution,
1. We will make the Excel sheet with details like Customer Name, Salutation etc., in addition to the Eail and screenshot, so that it can bring more personal touch.
2. We will make a Outlook Mail Compose Template with your personal messages (both Subject and Body) and place holders for the fields from Excel.
3. We will make an Outlook AddIn that will create a button in Outlook Compose window ribbon. Upon clicking the button, it will ask to select the Excel created above. Upon selecting the Excel, the AddIn will send the Email for each line in the Excel by replacing the place holder in the Template. The email will be sent separately for each row.
Thanks,
Nalla