@mp123 using the Report Text tool you can achieve this in the email
thanks for the reply.
But how to embed link to the image which makes it clickable when sent in an email. I could not achieve it with the suggested approach.
Did you figure this out? The Report Text would become the body of your email. So you could then use that field for the link.