Hello All, I have a master sheet in which column C has names of employees, and i have data from Column A to Column AE, The number of rows change from day to day.
I need a macro to send the rows to each employees as separate attachment via email, for example: if raj has 50 rows, it must get emailed to him as a separate excel attachment with all the formats through outlook, then ram has 60, those 60 rows alone must be sent to him as separate attachment.
The employee name in column C is the email id of each employees. there are more than 30 employees, so filtering and copying and pasting into new sheet and then attaching to mail takes a lot of time, please help me out.
I have been searching all over internet but couldnt find any, so please help me.
I need a macro to send the rows to each employees as separate attachment via email, for example: if raj has 50 rows, it must get emailed to him as a separate excel attachment with all the formats through outlook, then ram has 60, those 60 rows alone must be sent to him as separate attachment.
The employee name in column C is the email id of each employees. there are more than 30 employees, so filtering and copying and pasting into new sheet and then attaching to mail takes a lot of time, please help me out.
I have been searching all over internet but couldnt find any, so please help me.