VBA Mail with multiple CC

Hi,

I am new in the forum. I would like to ask you a question about vba mailing. I can do it simple like a mail with a receipent, a CC and a subject only. But this time I need with multiple CC's, changeable mail body and image inside of the body (with center align)

Image Banner

Body

Reason 1
Reason 2
etc.

Image Banner


I have three sheets on excel. List, body and reason. I need to send auto mails with this draft. Reasons can be more than 2, so I have to use FOR there, but I dont know how and I need to put it under body message as a table. Reason topics can be added as new columns next to subject in list sheet. If anyone help me here, I would be glad. Not sure if it's easy but complicated for me.

Hi again. Thanks for interest. I've updated excel file.

I need to add recipients, CC's (max 4) and the subject from the sheet, also the reasons, and I would like to create a table for the reason list. You can see it from the new excel file as draft.

For example, if someone has 2 reasons, I just need a 2x2 table (except header) for reasons, and otherwise 3x3 etc. But maximum is 4.

Also, I need changeable body for the recipient. For instance, Dear Student "TO". I would be glad if I find a solution here. I dont have to do it with three different sheets. If there is easier option, I would be happy.

Thanks maniacb, this works great. I want to ask three questions.

How can I make the body message center align?
I did my banner image center but I can not do it for the body message.
So its like

Please Login or Register  to view this content.

I want to make body as long center as I did for image.


How can I put changeable text fed from list sheet in the body? For example, Dear "TO".. And TO changes by the value from list sheet K2.

Last one is about table. I would like to see the table with borders. Is it possible?