Automatic Email and/or page someone conditional on value of cell/range

[SpeedThink]

I don't know if this is possible but I will ask:


Is it possible to use VBA within Excel to "automatically" page someone on a daily or weekly basis if a cell or range on my worksheet exceeds a certain value? (Note, Lotus Notes have a paging feature whereby one can send a page to someone who is listed in the Lotus Notes Directory).

 

[GrayShades]

I don't know anything about Lotus, but the following might point you in the right direction:

http://216.92.17.166/board2/viewtopic.php?t=327&highlight=lotusnotes

 

[SpeedThink]

GrayShades,

This definitely pointed me in the right direction as far as automating the email of the workbooks!

Upon reviewing the code in detail and reviewing the objects within Lotus Notes, hopefully, I should be able to derive a draft of the script needed to send a text page containing data from a particular range on my worksheet to the endusers.

Thanks.