I have a lookup file like below, the query should send mails to each person with that respective row information. and if mail1 column is empty, then query should consider mail2 column value to send mails. and if mail2 column is empty, the query should consider mail3 column value to send mail. and if mail1, mail2 are empty then query should consider mail3 column value to send mail. Emp occupation location firstmail secondarymail thirdmail abc aaa hhh [email protected] [email protected] def ghjk gggg [email protected] [email protected] ghi lmo iiii   [email protected] jkl pre jjj     [email protected] mno swq kkk [email protected] [email protected]   example, [email protected] receive mail like below in tabluar format Emp occupation location firstmail secondarymail thirdmail abc aaa hhh [email protected] [email protected] mno swq kkk [email protected] [email protected]   so likewise query should read complete table and send mails to persons individually....containing that specific row information in tabluar format. Please help me with the query and let me know incase of any clarification on the requirement. ... View more