VBA 365 code to set up e-mail with multiple attachments and multiple users using an excel table

[Daccota_lenny]

Hello!

I have a process that I have to do each month that requires me to e-mail multiple different people with different attachments on each e-mail, however the subject line and body of the e-mail is always the same.
I am planning on sharing this with other users who don't know much about excel so I think it best to have a shared excel table that they can plug in the information and then we can run the macro all at once for a mass e-mail.

Right now my test table looks like this:

I don't really know much about VBA - can anyone help with the code? I do know I need it to work on a loop so that each line is sent as a separate e-mail from the last. This will save my team countless man hours! I appreciate you all

 

[mumps]

It is hard to work with pictures. It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). How many attachments can there be? Can individuals have a different number of attachments?