It's Sunday, and I've been working since 5AM. I said I would post a new blog, and here it is!
If you like this video, please hit the subscribe button!
This is a lecture I recorded in response to a student question in the VBA part of the course (Excel Essentials Level 3 - VBA Programming)
All the code is there on the screen for anyone to use, free, gratis, and for no charge :) Though I hope it will guide some of you to get the course...you should, it's really useful.
This video is taken from my Excel tutorial course, Excel Essentials Level 3, which will teach you everything you will ever need to know about coding in VBA.
This is another student question about using VBA in Excel to automate the sending of emails from Microsoft Outlook.
Well, we cover the emailing routine in depth in the course "Microsoft Excel Essentials Level 3", but this is a kind of add on to that. The question was...if I have a bunch of different documents, in different languages, can I send a specific language document to a specific recipient based on a value in a cell. So, we will have a column that says French, German, Spanish or whatever, against a list of hundreds or thousands of names, we want to ensure the right language file gets added as an attachment for each person. Easy! And in this video, I'll show you how.
Okay, you will find the full VBA code here, with a complete walkthrough of what each line does.
Enjoy!
Be sure to check out the other videos on the channel...there are quite a few!
Videos in the Level 1 series:
Videos in the Level 2 series:
Videos in the Level 3 series: