searching in Google "excel vba outlook mail with template" i found e.g.
https://www.datanumen.com/blogs/2-qu...e-outlook-vba/
I added functionality: use of one or more outlook templates (.xxx.oft). You only have to add the path in the table "tblTemplates". Then you can select the appropriate template via pulldown.
you can format the templates as you like it. I provided one sample file.
I changed your data into a table ("tblAddresses"). If you don't like it then simply remove the table, use a Named Range or access the data in a different way.
If you double click on any cell in column "Supplier / Trade" (connected to event "Worksheet_BeforeDoubleClick") an Outlook mail will be generated according the template. If you do not need/want a template then modify the code and (un)comment the corresponding line
Bookmarks