Excel sheet email from outlook by Macro

I have a supplier master data sheet having supplier name, to email, cc email and email subject and I have also two more tabs of supplier, in this example Abc and Xyz. I want to email Abc and Xyz sheets as attachment to their email (As mentioned in supplier master sheet).
Does anyone know that how Can I do this macro or VBA?

have you seen this?

https://trumpexcel.com/send-single-e...il-attachment/

if that doesn't work, you can do anything with code.

.
Here is another resource :

https://www.rondebruin.nl/win/s1/outlook/mail.htm

See if this meets your requirements

Please Login or Register  to view this content.