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

[Sanket Katdare]

Dear Team,

Greetings,

Looking for a VBA solution that will allow me to send multiple emails through https://outlook.live.com/mail/0/ 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

 

[petergroft]

Go to Mailings > Insert Merge Field, and then choose the fields to add. In your main document, select Drag fields into this box or type text, and click or tap the text to remove it. Add and format the fields you want to be included in the email message, and choose OK.

This May Work,
Peter