Downloadable file updated, here's the link to it: www.teachexcel.com/excel-tutorial/2665/send-email-invoices-from-excel-in-pdf-format?src=yt_comment_pinned Here are our courses, in case you'd like to learn more: www.teachexcel.com/premium-courses/?src=yt_comment_pinned
Great video! I've managed to ge tthis working and I was wondering is there a way to include a button on the generated PDF file so that a person can click to submit payment for the invoice?
Hi, great video and well explained. Just one question: I'm not using outlook, would it work also with Thunderbird ? Of course I'd change some vba code lines. Thanks Bob
Hey, great video ! However my invoice loop's thru a drop down list , it saves all 50sh invoices pretty quick and I was wondering if it's possible to include in your the process of mailing each one , do you have any suggestions or any pointers, thank you !!
ICYMI, in the download file the name "headerRow" refers to "='C:\Users\0\Sync\Excel Related\Tutorials\[Dynamic Formulas Made Easy - 2 Methods.xlsx]Method 2'!$B$13", and "subtotalRow" refers to "='C:\Users\0\Sync\Excel Related\Tutorials\[Dynamic Formulas Made Easy - 2 Methods.xlsx]Method 2'!$D$18". Interestingly enough, if the file "Dynamic Formulas Made Easy - 2 Methods.xlsx" is in the same folder, Excel will correct the path. I had to (temporarily) delete the file to get the original path. I assume "headerRow" should refer to "=tableInvoice[#Headers]", and "subtotalRow" should refer to "=Invoice!$D$18".
Thank you so much for this comment!!! I accidentally uploaded the incorrect file, which had links to a previous tutorial. The file has been updated and you should be able to download the correct one now. (Only difference is the named ranges were removed and one was added for InvoiceFor.)
Downloadable file updated, here's the link to it: www.teachexcel.com/excel-tutorial/2665/send-email-invoices-from-excel-in-pdf-format?src=yt_comment_pinned
Here are our courses, in case you'd like to learn more: www.teachexcel.com/premium-courses/?src=yt_comment_pinned
Thanks for the tutorial = How do I make the button?!
Thank you for this insightful Video 📹 👏
Great video! I've managed to ge tthis working and I was wondering is there a way to include a button on the generated PDF file so that a person can click to submit payment for the invoice?
Thank you. How to monthly pdf invoices from ERP or EHR software to customers via email?
Hi,
great video and well explained.
Just one question:
I'm not using outlook, would it work also with Thunderbird ?
Of course I'd change some vba code lines.
Thanks
Bob
Hey, great video ! However my invoice loop's thru a drop down list , it saves all 50sh invoices pretty quick and I was wondering if it's possible to include in your the process of mailing each one , do you have any suggestions or any pointers, thank you !!
Where does this file get saved on your computer?
ICYMI, in the download file the name "headerRow" refers to "='C:\Users\0\Sync\Excel Related\Tutorials\[Dynamic Formulas Made Easy - 2 Methods.xlsx]Method 2'!$B$13", and "subtotalRow" refers to "='C:\Users\0\Sync\Excel Related\Tutorials\[Dynamic Formulas Made Easy - 2 Methods.xlsx]Method 2'!$D$18".
Interestingly enough, if the file "Dynamic Formulas Made Easy - 2 Methods.xlsx" is in the same folder, Excel will correct the path. I had to (temporarily) delete the file to get the original path.
I assume "headerRow" should refer to "=tableInvoice[#Headers]", and "subtotalRow" should refer to "=Invoice!$D$18".
Thank you so much for this comment!!! I accidentally uploaded the incorrect file, which had links to a previous tutorial. The file has been updated and you should be able to download the correct one now. (Only difference is the named ranges were removed and one was added for InvoiceFor.)