Excel Macro to Send Multiple Emails w/ Attachments using MS Outlook 2007
Hi Sir/ Madam,
I am trying to create an excel macro that will automatically send multiple emails with corresponding attachments to multiple recipients but my knowledge is not enough to run the codes. I decided to post it here because I believe somebody can help me or at least give me an idea on how to properly set the codes.
In this regard, I am wondering if there could be someone that can help me with this. I have attached the excel macro sample template that will give you enough data to come up with the output I needed. (Please, column A to G of 'Sheet1' will be the fields to be filled in with the NEW data).
Please let me know should you need any additional details. Any inputs and ideas from your end will be highly appreciated. Thanks!
Warmest regards,
Arnel
Last edited by arnel_10; 03-16-2017 at 10:28 PM.
Reason: Excel Macro Sample Template attached
If you feel someone has helped you please thank them and click on the star on their post to add reputation.
Please ensure that you use code tags where relevant, and mark solved threads as solved.
Most of all please be respectful and understanding of others.
Re: Excel Macro to Send Multiple Emails w/ Attachments using MS Outlook 2007
Hi Stephen,
Thank you for your immediate feedback and I am also glad that you are the one who answered my query.
I tried the VBA codes above and it works. However, the attachments were not captured. I already checked the raw data (i.e. File Path and File Names) and it looks alright.
I really appreciate if you could please help me check the codes again until the attachments are captured. Thanks!
Re: Excel Macro to Send Multiple Emails w/ Attachments using MS Outlook 2007
Hi Stephen,
Awesome! It works perfectly and it's like magic!
Thank you for helping me once again. I will take note of the codes that you have shared and will keep on practicing until I become like you in the future. I am glad seeing myself helping others too in the near future. Kodus also to this website.
Bookmarks