VBA auto email

[Shneederling]

Hi all,

We have a tracker for stock waiting to be booked in. When our warehouse has booked in the stock, they enter 'Closed' into a particular cell, add a comment, and the line turns blue. How can I set the spreadsheet up so when the warehouse enter 'Closed', an email is created with the comment added and automatically sent to the person who originally added the line?

 

[Logit]

.
Wonderful. Glad to help.

 

[antoanand1981]

Hi All,

I've question here, and need help, I've similar code which was working fine in 2010 but i am facing an error in 2016 excel. The bug am getting when it hits .Publish (true) can you help here.

 

[Shneederling]

.
Wonderful. Glad to help.

Hi,

Have a small issue, when the email is produced, it cuts a lot of the txt off from the spreadsheet. So when someone types in what they have done, it only shows part of the txt

 

[Logit]

.
Please create the scenario you are seeing there. Then save that workbook
and post it to a cloud site for download.

I've attempted to re-create your situation here without success.

 

[Shneederling]

.
Please create the scenario you are seeing there. Then save that workbook
and post it to a cloud site for download.

I've attempted to re-create your situation here without success.

Not to worry now Logit, my manager says what is produced is perfectly fine. Thanks

 

[Logit]

.
Ok.