Hi Guys,

I have had a little trouble finding a suitable macro for this problem, so your help is appreciated.

In short, I require a macro that can do the following (and have attached a sample workbook with another macro built in which does something else, courtesy of another forum member some time ago):

1. The existing macro captures data from a live DDE feed, and lists it in one second intervals in another tab (called DATA LOG 3)

2. In cell C68 under tab DATA LOG 3 (highlighted blue), if a set of conditions is met from the collected data, the number "3" appears in this cell.

3. As the data is from a live stream, as soon as the conditions are no longer met, the number 3 disappears.

4. I need a macro which can run smoothly alongside the existing one, and which sends me a simple email with no text and the word "ALERT" in the subject line.

5. The email address is a [email protected] address.

6. I need the email to only send ONE email each time the number three appears.

I look forward to receiving your answers, thanks again!SAMPLE WORKBOOK FOR EXCELFORUM.xlsm