Good evening everyone,
during a private small "invoicing" project, I was forced to use VBA, which is a complete new territory for me and I started to watched the videos from Chester Tugwell,
who did a great job (at least, I think so), showing some VBA code, how to setup a simple automated invoicing tool.
https://www.youtube.com/watch?v=lEgg...nnaD57&index=6
In the last series (see link above) he shows, how to prepare an invoice in Excel, to be attached as an pdf to Email and to send it by Outlook.
The code for this part looks like as seen below:
I wonder, how to extend the code on such way, so it is always sending the mail from a specific email address?
I will add the Excel that contains the full macro.
Thank you very much for your help and support,
Mike
Bookmarks