November 8, 2013 - Warren Held

Generate Emails From Excel Using VBA

I was tasked with double checking that the hardware we had listed for the employees in our inventory management system was up-to-date.  In order to do this I was going to send out a lot of e-mails.  I like to live by the motto of “work smarter not harder”.  I wrote a VBA script that would generate e-mails in Outlook and would pull information from the spreadsheet I had of the users equipment and use that info in the e-mails.  Now I just have to figure out how to imbed images in an e-mail using VBA.  If you have any questions or know how to imbed images in the body of the e-mail (not linking them with html to a web server) feel free to leave a comment.

 

Office 365