Using VBA to send email from cell

Hi all, I have some code which sends an email to the address stored in cell U8

If the email address is typed, it works fine. If it is entered as a formula using a lookup to find the email address it fails.

Any help with this as it seems quite illogical?

The code snippet is below

Please Login or Register  to view this content.

Hi,

The value in 'U8' must be a valid Email Address.
Try some intermediate code to try to debug.
For Example (not tested):

Please Login or Register  to view this content.

If there are embedded spaces or no @ sign in the Email address you will probably get a failure.

Good Luck

Lewis