VLOOKUP causes automatic emailing to fail


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?




It works now.  I recopied the original from the tutorial, modified it for my purposes and this time it works.  I have no idea why it works now and didn't before. User Error!



Well, I'm glad it works haha. Thanks for posting the follow-up!
don (rep: 1825) Jan 30, '20 at 12:23 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login