Dear Experts,

I am trying to attach excel files under a particular directory into new email drafts using macros.
Example: if there are 10 files under that directory then it has to create 10 different email drafts with the attachments.

Can experts help me with some code

Thanks.