I have problem with this piece of code. I tried to use awk to send mail but it failed. Please help me

for i in $( cat /tmp/a)

do

cat /tmp/b | grep $i | awk ' {mail -s  " $2 is your new ID"   $1@companydomain.com }

done

cat a
Joe
Mic
Noah

Cat b 
Alan 2313
Joe 223
Mic 768
Charlie 565
Noah 2656

cat /tmp/b | grep $i | awk ' {mail -s  " $2 is your new ID"   $1@companydomain.com }'

awk '$0~inp {mail -s  " $2 is your new ID  $1@companydomain.com" }' inp=$i /tmp/b

It is still not working

It gives me error ( invalid char @ in expression ) !!

Here are a couple of ways to do what you want:

#!/bin/ksh
echo simplififed translation from given code
while read i
do      grep $i /tmp/b | awk '{printf("echo mail -s \"%s is your new ID\" %s@companydomain.com", $2, $1)}' | ksh
done < /tmp/a

echo awk replacement
awk 'FNR == NR {
        newID[$1] = $2
        next
}
{       printf("echo mail -s \"%s is your new ID\" %s@companydomain.com\n",
                newID[$1], $1);
}' /tmp/b /tmp/a | ksh

Thanks Cragun . It's working now