Previous Work
Bulk Attachment Email Generator
In this project, I created an excel based application that allows you to create multiple emails with multiple attachments and send them en masse. This can be used to send multiple emails with different subjects to multiple people, or send multiple attachments over separate emails with separate subjects to the same person
Multifind Function - Add-in
In this project I wrote an Add-In that allows the user to pull out multiple entries for the same value from a table.
Essentially a vlookup or index/match that will return multiple values.
Code can be downloaded in the downloads section and a class on this project will be coming soon
Automatic Document Generation
In this project, I created an excel based application that allows for invoices to be generated from a database, saved locally, emailed and printed automatically. The interface requires population of data, which will then be dissected, used for the individual emails and then moved to a storage database where it can be later viewed with the assistance of slicers. The skeleton of this application can be adapted to open all files in a folder, or generate word documents for every entry in a database and so much more.
Europe Data Map
This is a section of a project I put together to have a visual aid when dealing with location data. I put all the countries of Europe into this example, but it looks a bit cramped. This could edited to reduce overcrowding.
Sample file available in downloads section.
More project videos to follow.