Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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: 1989) 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