Mail attachments

[Pradeep Gupta]

Hi All,
I am having an Excel file which contain several sheet, my problem is that I have to send each sheet separately to individual user through mail as attachment with password protected.
Kindly provides solution for above query.
Regards,
Pradeep Gupta

 

[Deepak]

Hi,

Check the below link.

http://chandoo.org/forum/threads/split-files-according-to-country.17585/

If it doesn't helped then pls share the sample workbook.