How to send an email automatic when a cell is updated

Closed
John - Sep 1, 2016 at 12:32 PM
xpcman
Posts
19532
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 reply

xpcman
Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,965
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
0