automatically fill template and create Outlook mail

Hi..

1. For e.g. a country as United Kingdom in the example file, I have multiple mail addresses in the TO and in the CC line. Is it possible to include all of these addresses in the Outlook mail?

I added it so 7 Recipients and 2 CC's will be included (as per your uploaded sample file)..

I added some more vlookups in the "SA" sheet to enable this..

.To = Sheets("SA").Cells(2, 13).Value & ";" & Sheets("SA").Cells(2, 14).Value & ";" & Sheets("SA").Cells(2, 15).Value & _
                ";" & Sheets("SA").Cells(2, 16).Value & ";" & Sheets("SA").Cells(2, 17).Value & ";" & Sheets("SA").Cells(2, 18).Value & ";" & Sheets("SA").Cells(2, 19).Value
.CC = Sheets("SA").Cells(2, 20).Value & ";" & Sheets("SA").Cells(2, 21).Value

2. If there are multiple lines for 1 country in the "HUB Outbound HTM daily report" sheet, will it create multiple mails at the same time when clicking the "Send Emails" button?

Yes .. it does that..

As you can't check on Outlook atm.. see the screenshot..

shot1.png