Macro to fetch data from excel and save it as draft email at specific folder location

[shaikhstonevilla]

Good Morning,

I need some help from you guys creating a macro in excel/outlook.

My excel spreadsheet contains details as under.

Column A : Client names
Column B : Outstanding Amount
Column C : Due Date

I want to create a macro which can perform as under.

1) Macro should take Client names, Outstanding Amount and Due Date as email body text.
2) Subject Line of emails should be "Client name_Reminder_Todays Date
3) Save the draft email at D:/clients

Could you please help me creating a macro ? It will save lot of time of mine.

Many thanks,
Tim