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?
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.)
VLOOKUP causes automatic emailing to fail
0
Answers
0
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!
Discussion
Well, I'm glad it works haha. Thanks for posting the follow-up!
don (rep: 1989) Jan 30, '20 at 12:23 pm