Invoice in Excel Part 5 - VBA macro to send PDF of the invoice by email @EXCELeINFO

Опубликовано: 13 Октябрь 2024
на канале: Sergio Alejandro Campos - EXCELeINFO

61,686

1.1k

✅ Download the file | http://www.exceleinfo.com/factura-en-...
🏆 Subscribe | https://goo.gl/M5zNA8

In this fifth and last of our Project Invoice in Excel we will develop a macro VBA step by step which will help us to send the PDF of the invoice by email. But first we will modify the macro that generates new invoices and we will indicate that when saving the invoice data in the Invoice detail sheet, also save the full path of the generated PDF file and so the Send mail macro will take that address and the name of the PDF files to attach them in an email. You must have Outlook Office installed on your PC for the macro to work.

The advantage of this macro is that if you have several accounts configured in Outlook, you can choose which one to send the PDF file of the invoice.

I must give you some clarifications that you must take into account to use the macro to send Emails.

We will use Office Outlook to send the emails.
◾We must activate a reference to the same Outlook.
We can attach any file in the mail.
◾ If you have several accounts configured in your Outlook, you can decide which one the invoice will be sent to.

More examples | http://www.exceleinfo.com
More examples | http://blogs.itpro.es/exceleinfo
Facebook Page | / exceleinfo
Get notificacions on Telegram | https://t.me/EXCELeINFO
Twitter | @EXCELeINFO
Twitter | @SergioACamposH

Download EXCELeINFO addin:
http://addin.exceleinfo.com