Email with Multiple Attachments through VBA

Solved/Closed
Game Start Now Posts 138 Registration date Thursday January 21, 2010 Status Member Last seen May 8, 2019 - Updated by Game Start Now on 2/01/17 at 03:38 PM
 Blocked Profile - Jan 10, 2017 at 05:07 PM
Dear All,

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.

Thanks in Advance.

Looking forward to your usual co-operation.

Regards,
Game Start Now

2 responses

Blocked Profile
Jan 3, 2017 at 05:01 PM
Well, where are stuck? The mail object? The formatting of the email structure itself? I will not! For certain, will not provide a mailing program turn key. Let us know where you are stuck!
0
Game Start Now Posts 138 Registration date Thursday January 21, 2010 Status Member Last seen May 8, 2019 7
Jan 3, 2017 at 11:38 PM
It doesn't stuck anywhere. I am in need of such Macro.
0
Blocked Profile
Jan 4, 2017 at 04:14 PM
Sorry, macros cant build and instantiate a mail object! It cannot be done with a macro!

You must include a package on load, and reference it to make it work!
0