Send bulk emails (Mail merge) outlook.live.com/mail/0/

[sanket_sk]

Dear Team,

Greetings,

Looking for a VBA solution that will allow me to send multiple emails through Outlook using excel.

Sharing excel format from where Macro will pick details and send using outlook.live .com including attachment.

Kindly guide me if possible

To	CC	BCC	Subject	Mail Body	Attachment 1	Attachment 2	Attachment 3	Attachment 4	Attachment 5
Sample1@Outlook.com	SampleCC1@outlook.com	SampleBCC1@outlook.com	Weekly Update	Dear Sanchita, Please find attached report. Thanks & Regards, CC Team	C:\D\Reports\Weekly report Sample1.xlsx	C:\D\Reports\Weekly Summary Sample1.xlsx	C:\D\Reports\Weekly Detailed Sample1.xlsx
Sample2@Outlook.com	SampleCC1@outlook.com	SampleBCC1@outlook.com	Weekly Update	Dear Sanchita, Please find attached report. Thanks & Regards, CC Team	C:\D\Reports\Weekly report Sample2.xlsx	C:\D\Reports\Weekly Summary Sample2.xlsx	C:\D\Reports\Weekly Detailed Sample2.xlsx

Thanks in advance

Thanks & Regards,
Sanket