Building a macro in excel to send multiple email on a single click

Job ID: 33351865

Budget: ₹1,500 – ₹12,500 INR

Hi ,
I do email marketing and sending email one by one making changes in the subject line and content is quiet tiery and it reduces the efficiency. So i need a macro to be developed in excel that automatically picks up the first name and the last name and add it to the mail subject and to the mail body also wherever required. And on clicking send all the mails must be sent to the recepient with this first name and last name in the subject box and also in the body