Create Excel Files & Email

[zain16nib]

Dear,

Given below data has based on 5 BM's of his clients data with there emails. i have two requirements.

1. create BM excel files in particular location for example: location c:\BM\06-01-16\B-1.xlsx B-2.xlsx.......... so on.
2. email BM particular file to given email address.

Kindly guide how to achieve above requirement through macro or else with nprinting.

Thanks in advance.

Regards,

Zain.