Hello, I have an excel file that is updated automatically from some websites. This files contains products prices. I want to send automatically an email when the price drop under a value. Is there a way How to send email using VBA Excel?How to Send Email in Excel Using VBA? Thanks for your help
0
0
Be the first one react
Hello, You need to give access Outlook with VBA, you need to activate the Microsoft Outlook Object Library. To activate it, go to Tools in the VBA editor > References. Activate Microsoft Outlook 16.0 Object Library : Then in a module use this subroutine: Sub sendAnEmail(ByRefRead more
Hello,
You need to give access Outlook with VBA, you need to activate the Microsoft Outlook Object Library.
To activate it, go to Tools in the VBA editor > References.
Activate Microsoft Outlook 16.0 Object Library :
Then in a module use this subroutine:
[crayon-6763fcf01c322200657811/]
To test the code, call this code using a buton:
[crayon-6763fcf01c326872495758/]
Test:
I hope this will help you.
Good luck!
See less