Email different people with dynamic body from table

Hi everyone

I'm completely new to VBA, but I need to take care of automating something at work. I've followed a great Youtube tutorial by Chester Tugwell called "VBA to Automate Sending Email From Excel Table with Attachment from Folder", but instead of attaching an existing file, I need to add an Excel table as part of the email's body. The contents of the table need to be selected from an existing table in a separate file, based on a couple of conditions.

I have two files (attaching both). One is "Example MList" which is a mailing list, and the other is "Example Surveys", which contains a table with client surveys for cases worked by the recipients listed in the MList. I need the body of each email to contain rows from the Surveys file, where the name of the case owner is equal to the recipient, the date of the case is >= than the date listed in the MList, and the Resolved field =0.

In the MList file, I've saved the VBA code I have from the Youtube tutorial, but the body part is what I'm having trouble with.

Any help is much appreciated. First post in this forum, so hopefully I'm not violating any rules or etiquette, but do let me know.

Cheers

This is the code I have so far

Please Login or Register  to view this content.