I have just been using the excellent tutorial Send Emails from Excel - Automatically and by Hand.
My question: I want to use an email address on the worksheet, however it is on the sheet as a result of a VLOOKUP formula from another sheet. This causes the macro to fail as it is obviously looking for an email address and has been directed to a VLOOKUP formula. What can I do about this, please?