VBA - create email and add attachment from a table

[OBP]

Then your code for saving it as a file and then attaching it is the only way that I have found to do what you want VBA wise.