VBA - Splitting data into new workbook and send emails

[Mahesh Babu]

Hi,

I am looking for VBA code with the below requirement:

I have columns like Name, ID, State and zip code.

1. Filter data with State column
2. Copy all the respective rows along with the header into a new workbook (Different workbooks for each unique state code)
3. Save the workbooks in a given path with name as state code
4. Send each workbook as separate email as an attachment.
5. Email address should fetch with the help of vlookup with state code in a different spreadsheet.

Thank you so much for your help in advance.

Regards,
Mahesh Babu

 

[Chihiro]

You'll find base code for what you want to do in link below. If after trying, can't implement. Then post your attempt along with specific issue you are encountering.

https://www.rondebruin.nl/win/s1/outlook/mail.htm