Скачать с ютуб VBA to Automate Sending Email From Excel Table with Attachment from Folder в хорошем качестве

VBA to Automate Sending Email From Excel Table with Attachment from Folder

Download the featured file and get the code here: https://www.bluepecantraining.com/vba... In this video I demonstrate how to automate sending emails (including attachment) from Excel. To do this you will need to use VBA - code included in the download above and in the description below. In our scenario we have a table containing training delegate details. The table includes name, email address, course title and course certificate file name. By looping through each row in the table using a For Each Next loop we can create an individual email for each delegate adding their details to the to, subject, body and attachment properties of the email. Here's the code featured in the video: Table of Contents: 00:00 - Introduction 01:12 - Show the Developer tab 01:33 - Open the Visual Basic Editor 01:52 - Start writing your code 02:14 - Declaring variables 08:00 - Start the For Each Next loop 16:08 - Create a button to run the macro ------------------------