Create and Send PDF Reports Using Excel VBA || Beginner - Intermediate Project || Uni Report Cards
Build an extremely useful project from scratch, where we will create PDF report cards from university marks' dataset and email them out to the respective students.
This project is filled with a variety of code snippets including:
Filtering of data using Advanced Filter
Performing lookups using Range.Find()
Creating Sub and Functions with parameters
Building Select Case statements instead of Nested Ifs
Send email with attachments
Check if file exists using DIr()
etc.
Files can be downloaded from Github:
https://github.com/skillsandautomatio...
Code can be obtained from the blog page:
https://skillsandautomation.com/proje...
00:00 Intro
00:47 Demo
03:31 Initial Excel File
04:14 Macro 1: Clear Data
05:16 Build Main Parent Macro
08:27 Isolate Each Student Data
13:13 Populate Report Template
22:03 Create and Send Email Template
26:02 Final Test
