Learn how to find the last row of a dataset in an Excel worksheet using the CurrentRegion technique. We will also, discuss UsedRange for times when CurrentRegion is inadequate.

Learn how to send an Outlook Email using Excel VBA via a separate sub-procedure. This will make our main sub neater and easier to manage.

Learn how to connect to Outlook using Excel VBA and send a basic email. We will also, cover how to attach files.