Send as email on workbook open

[HereComesTheBoom]

I've been trying to insert a workbook open where the whole wb gets sent to an email everytime its opened, but cant for the love of God get it to work, does someone have a vba for doing so?

The CATCH is, it's not supposed to start this sending until we cross the date 4/10-2019

[BadlySpelledBuoy]

Maybe something like this?

Please Login or Register  to view this content.

BSB

[HereComesTheBoom]

So, the problem is - im testing it as module without the if-statement, like this.

Please Login or Register  to view this content.

And nothing sends, I'm blind

[nigelog]

Have you a valid email address here

Please Login or Register  to view this content.

[HereComesTheBoom]

Yes, my own

[nigelog]

works here - have you placed code in workbook module

Please Login or Register  to view this content.

[HereComesTheBoom]

Yes, it's in a module.

Could this be because I have another Workbook_open in This_Workbook?

There I have this running

Please Login or Register  to view this content.

[dominicb]

Good morning HereComesTheBoom

Could this be because I have another Workbook_open in This_Workbook?

Yes - you must roll all the code in your Workbook_Open module into one module.

HTH

DominicB

[nigelog]

Rename the email code and place in ordinary module

at the end of your open workbook above add the line

Please Login or Register  to view this content.

in otherwords call the email macro from your code above