Edit outlook draft & send email

[itzashish]

Hi Champs,

Here is a challenge.

I'm having a generic outlook email draft to be sent out 100 times in one batch to different recipients. There would be a couple of editing done before sending it out.


E.g. is below


Outlook draft:
To: xyz (Editable)
Sub: This field is static




Body:


Dear recipient (Name is Editable),


Your bill has been generated. Please go through the attached invoice & take proper action.


***A range from excel*** (like B5:K40) varies each time


Regards,
Company Name



Any quick help will be highly appreciated.