I want to send 120 e-mail with 120 attachments

Dear Rizvisa1,
Thanks a lot for your interest and help. I have two cases:

First case: I have 120 excel sheet in a workbook. Each sheet represent a monthly pay slip for each employee. I want to inform you here how normally I distribute them, I print every sheet as PDF, I mean convert each excel sheet to PDF file separately and then save all of them in one folder, then I cut each created PDF file and paste it to each employee's personal folder. This takes me a lot of time.
What I need here if possible is to send all the employees e-mail (Merge mail for instance) with the attachment (PDF) which this instead of distributing them to their personal folder. Or if possible to send them the excel sheets directly without converting to PDF or to send at least the data from each excel sheet. I'm looking to save my time instead of converting to PDF then cut and paste to each personal folder. By the way, I have their e-mails as a list.

Second case: I have one excel sheet includes the following data:
Column A: The E-mail for each employees.
Column B: Employee's names
Column B: The amounts that transferred to each employee's account.
What I need here is to send each employee e-mail to inform him with amount only that transferred to his/her account. How could I do it automatically not manually, I mean to use any programing (VBA) or to convert the data to word then use mail merge or any other possible way.

Thank you in advance for any possible assistant and will be highly appreciated.
Issa

One easier solution that comes to my mind is that why not have a macro that loops thru the sheets it self and print the pdf file directly in the folders ?