I need to send the multiple emails via Outlook through VBA.
Column A Row 2 = Name of Person, Which must be Displayed on .Body
Column B Row 2 = .To Email Address (It could be multiple)
Column C Row 2 = .CC Email Address (It could be multiple)
Column D Row 2 = .Subject
Column E Row 2 = .Attachments.Add (It could be multiple)
Sheet2 is the Matter which must be copy and paste to the .body
I need looping Macro to send the emails one by one with attachments or attachment with the formatted body which is located in Sheet2.
Note: Sheet2 Matter will remain same for all rows.