Add the action
Now, click +Add Action & choose Send Email.
Enter your digital marketing manager's email ID, subject line & custom message.

Note: Ensure that you enable automation to complete the process.
GIF - Showing Action & Automation output
In the above GIF, you can see the digital marketing manager receiving an email once the status of the record changes to "Published" on the table Posts.