Elegant way to send Email in Excel to several recipients with an attachment

Hi, so first of all, we need to change some of your code.

1 - You'll need an attachment variable, containing a file location (ex. "C:\ajsdjasd\iasidfasd\workbook.xlsx")
2 - First Filter, then Save the workbook, so you can attach it already filtered. Or you can "Workbook.Add" to open a new one, paste the filtered table on to it, save to a location, and put that location+name in the attachment variable =)
3 - you will need to change your SendTO variable. The outlook accepts recipients as "name1; name2; name3; ..." So I advise you use one cell on your workbook, with
the formula:

Formula:

Please Login or Register  to view this content.

And then put this cell on your SendTO variable.

OK, now to the Email VBA, it's quite simple, here:

Please Login or Register  to view this content.