macro NOT WORK for cell value which contains formula(lookup)

[CLASSMATE]

I have a macro to send email from excel.
I have created a column "A" having email address, which infact is a lookup value from anotherworkbook.
My problem is when value in column A is manuelly entered, the macro runs & email is sent.
But when I use lookup formula in column A, macro gets run but no email is sent.
Any suggestion & Help. following is part of my macro.

Please Login or Register  to view this content.

[jaslake]

Hi CLASSMATE
The immediate issue is this line of code

Please Login or Register  to view this content.

You've told us that

I have created a column "A" having email address, which infact is a lookup value from anotherworkbook.

So, Column A does NOT contain Constants and accordingly will get bypassed. You might try

Please Login or Register  to view this content.

Not tested.

[jnsburks]

Had this issue for days!!! SOLVED for me!!! THANK SO MUCH!!!