Thread: Outlook macro to check a value of a cell in an attachment and send an email based on that value
View Single Post
 
Old 03-23-2015, 08:31 AM
gmayor's Avatar
gmayor gmayor is offline Windows 7 64bit Office 2010 32bit
Expert
  
Join Date: Aug 2014
Posts: 4,138
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
The macro triggers a message when the value in the worksheet is greater than the value of iCount. You have iCount at 25, whereas the worksheet cell E2 has a value of 20 (so as 20 is less than 25, there will be no message). Change the value of iCount to less than the value of E2 if you want a message.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote