Hello Gurus,
I have a question.

I have a file which has 2 columns and is tab separated and looks like below:

FIELD1 FIELD2

Manual m456@hotmail.com
Execution din098@gmail.com 
Artistic m456@hotmail.com
Graphic din098@gmail.com

Manual m456@hotmail.com
Artistic m456@hotmail.com
Execution din098@gmail.com
Graphic din098@gmail.com

awk 'NR>1 { print $2 | "sort | uniq" } ' input_file | while read mail_id
do
        awk ' BEGIN { print "Assigned Values: " } /'$mail_id'/ { print $1 } ' input_file | mailx -s "Group Info" ${mail_id}
done

awk '{a[$NF]=a[$NF] FS $1}END{for (i in a) print "Assigned Values: " ,a[i] |mailx -s "Group info" i}' infile

Thank you very much gurus bipinajith and rdcwayx, i really appreciate your quick help.

Thanks very much.

Hi bipinajith,

Actually the code would miss the first line and it's reading from the second line.
For instance if i have only one row of data, then there's no email sent to anybody.
I've tried removing NR>1 but it still does the same.
Can somebody help me with it please.

I put NR>1 to avoid the file header FIELD1 FIELD2

So removing NR>1 should work:

awk '{ print $2 | "sort | uniq" } ' input_file