Macro to e-mail different files to different e-mail addresses

[tibiliche]

Hello,

I have one big excel file with for example 100 rows and 10 colums. I want to break this file into multiple files based on the contents of a single column and then send email to separate persons.


For exemplification, in the following table I want to split into multiple small table based on the contents of the column 3 and send automatic emails to test1@x.ro, test2@x.ro, etc.

So, there will be 3 files and each file to be automatic sended to separate emails.

1	Paris	Andrei
2	Madrid	Peter
3	Belgrad	Andrei
4	Roma	Nick
5	Moscova	Peter

<tbody>
</tbody>

Thank you for your suport!