Excel VBA - Attach (Invoice) PDF to Email and Send to Email Address (Based on Cell Value)

Buy the Simple Sheets Invoice Template (all purchases help support this channel)
https://www.simplesheets.co/a/2147525...

Download the featured invoice template here
https://www.bluepecantraining.com/exc...

Full playlist for this video series:    • Create an Automated Invoice Template,...  

This tutorial is part of a series of tutorials that demonstrate how to create an automated invoice system in Microsoft Excel. This video looks at saving the invoice worksheet as a pdf and then sending it as an attachment via email.

Other videos in this series show you how to write VBA macros that
1) Create the invoice itself
2) Automatically generate the next invoice number
3) Add the invoice details to a record of invoices
4) Save the invoice as an Excel workbook



Table of Contents:

00:00 - Introduction
02:06 - Starting the VBA code for the button
02:52 - Declaring the variables for the macro
05:01 - VBA code to export worksheet as PDF
06:19 - VBA to find the next blank row in the invoice tracker
07:11 - VBA to copy invoice details to the invoice tracker
07:58 - VBA to create a hyperlink to a pdf
08:21 - VBA to create and send email with pdf attached (email address based on cell value)
11:20 - Create a button to run the macro
------------------------