Hi everyone,

Please see the attached image for reference.

I have to send out repetitive e-mails like this to different people all the time. I generate data on excel essentially and have to include it in the e-mail. If you look at the following image, you should be able to understand what I mean.
Is there anyway I can generate an outlook e-mail template using VBA that will allow me to inject data using Excel? I will not necessarily only have 1 or 2 items to include in each e-mail, on occasion, I can have up to 10 lines of items even.

I am new to VBA but have automated tasks before. I've been googling and searching on youtube for keywords that relate to outlook and user defined templates to no avail.

Could you please point me in the right direction?

Snipsnipvba.PNG