Daily Report automation-split excel & send auto mail

hi, team here is the sample file

Step1: The base sheet has the report summary

Step 2: need to filter Column D (header Name:"ZSM")

Step 3: Save the file as today's report -" Column Name" which is "A" with the Date

If there are 150+, I want to separate all the ones into separate Excel sheets in a folder with the desired saving Names (A-Feb 22nd report)

after that

Step 4:

want to send mail individually by picking the saved report from the desired folders where I also want to add CC
(if required can add a CC list in the base)

Step 5: emails need to be sent through Outlook to individuals as desired

Pls help solve this automation problem

Do you have code that you need assistance with or are you asking for someone to just do the work?

See sendmail from excel attachment.

SendMail.xlsm

Dear Team, have found a way to send bulk mail.

support required:

Step 1: split the base into different Excel sheet (based on the Mail id sheet)

step 2: place the split files with desire name in the temp path

Step 3: update the path in the mailed sheet

step 4: ask for send confirmation

done.

so, pls help with this.

Originally Posted by AliGW

Administrative Note:

Where you have provided a workbook solution, please also include a clear explanation of what you've done and how (including formulae/code as approriate) in the post in question (for the benefit of members unable to download attachments).

This is about making your assistance accessible to all.

Thanks.

Dear Team, can my request be solved or it's not possible. require u r assistance pls