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.

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]Paris[/TD]
[TD]Andrei[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Madrid[/TD]
[TD]Peter[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Belgrad[/TD]
[TD]Andrei[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Roma[/TD]
[TD]Nick[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Moscova[/TD]
[TD]Peter[/TD]
[/TR]
</tbody>[/TABLE]


Thank you for your suport!