Send Email From Excel 1

[VincentCrimmins]

Hi,

I want to create a macro that if a cell = 1, that it sends an email from my Outlook to a colleague to notify them.

The spreadsheet is linked to an external data-feed, so when the top row updates, and the Cell F2 = 1, it will send the email.

Any ideas?

 

[Chance1234]

Take a look at

faq707-3564
or
faq707-4334


Chance,

F, G + Its official, its even on a organisation chart et all