Hi Todd,

the idea you suggested worked. instead of @varcount = 0, i had to give @varcount <=0....thats it!!!!

thank you so much...

Regards....

Thanks guys....I will try this and let u know how it worked....

I have the query result going to the excel file and I'm sending an email with an attachment. But if the query does not have any result, I do not...