Hi gmayor

I just stumbled upon this thread and the original code is almost exactly what I am looking for in one of my projects and I was wondering if you could possibly help please.

I was trying to update the code to send multiple tables, for example in my code I would like to take tables 1 , 2, 8 & 9 and drop into the body of the email, but every time I tried kept getting errors .

Also is it possible to add a line of code to attach the active document to the email and name the subject of the email the active name?

If you could advice that would be amazing as I'm quite the macro novice.