Otherwise Excel stops the VBA code from running. When you open the workbook you need to allow Macros to run.

To follow along with article you can download the Sample Workbook “20180529-Send_Email_from_Gmail_Outlook_using_VBA.xlsm” by clicking here Exercise reasonable caution when following these instructions, and use at your own risk. Warning: While I provide this article for general education and information, I cannot be held accountable for any negative effects from using the VBA code below. Please do not abuse the code here to send spam emails! GDPR notice: Given the new EU legislation around Data Protection and Privacy (that came into force worldwide on )… it makes sense to respect and protect email addresses, especially when using any automation. Click here for instructions on how to access email parameters stored on your Excel sheet. Just adapt the relevant Macro and run it to generate your emails.Ĭlick here for the Gmail instructions. The VBA code and instructions (below) allow you to do just that… It explains how to send emails from Gmail and Outlook using Excel VBA.įor instance, you might want to set up an automated email system to send weekly email reports to colleagues – without having the manually specify To / Subject / CC / Email body / Attachments. Today we have a guest article from Perceptive Analytics.