I created a personal macro that would allow me to automatically send emails using Excel. The macro works fine if I am using the actual workbook where the macro was created but not on new workbooks. I believe the macro is generating the fields to search base on the work book where the macro was...
I need assistance sending an outlook email from an excel file with VBA.
Every email message will have the following content:
We are expecting the following NSCC Deposits.