Mail merge multiple data rows to one email address

[stebrownsword]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Email
[/TD]
[TD]Data
[/TD]
[/TR]
[TR]
[TD]Ste@google.com
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]ste@google.com
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]Bob@google.com
[/TD]
[TD]A
[/TD]
[/TR]
[TR]
[TD]Bob@google.com
[/TD]
[TD]B
[/TD]
[/TR]
</tbody>[/TABLE]

Hi guys

is there a way that I can mail merge 1 email with several rows of data, instead on several emails with 1 row of data?

desired result - Ste recieves 1 email which states 1+2 and bob recieves an email which states A+B

at the moment - Ste recieves 2 emails 1 email stating 1 the other email statin 2 , Bob recieves 2 emails 1 email wth A another email with B

 

[daverunt]

It's a browser link to a text file on Google drive- Just click on it.

 

[stebrownsword]

I've got the code etc, its when I run the code it comes up with Run-Time Error '424': Object required

I think its around - create the HTML table and header from the first row?

 

[daverunt]

I've cut and pasted the code and I don't see any issues.

I've sent you a PM. If you can send me a copy of the workbook with anything important substituted I'll take a look at it.

 

[daverunt]

Updated the code here.
It generates 2 mails for me to Test 1 (Row 2 & 3) and Test 2 (Rows 4-6)

https://drive.google.com/open?id=1HVcz4vJzFAOTVz_-733ZjSBcIMXmMcnj

 

[daverunt]

As Outlook sends mails in html format you can create a complete html page in vba to include the style headers etc.
This allows you to add css within the style tags to format the mail as you would any html document.
The code below sends the mail with selected fonts, style and colour, table background/border colour.

https://drive.google.com/open?id=1bhPkhgDto3CxeHC_XwkLDzvMzSibp30i