How to send an email automatic when a cell is updated

Closed
John - Sep 1, 2016 at 12:32 PM
xpcman Posts 19530 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 - Sep 1, 2016 at 01:03 PM
Hello guys,

I am imports coordinator I have a tracker created in excel worksheet which I use to track our shipments that arrive at port then proceed with clearance process and so on. I need to programme this tracker in such a way that whenever vessel arrives, and I update the arrival date by bolding the date value in cell along the arrival date column (because the anticipated arrival date is there always) then excel send an automatic email via outlook to alert my boss that the vessel has arrived please start to process payment.

1 response

xpcman Posts 19530 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,825
Sep 1, 2016 at 01:03 PM
Depending on your VBA skills you can check this site:
https://www.rondebruin.nl/win/s1/outlook/mail.htm

Good Luck