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-24-2015, 08:56 AM
ketangarg86 ketangarg86 is offline Windows 8 Office 2013
Novice
  
Join Date: Oct 2014
Posts: 11
ketangarg86 is on a distinguished road
Default
I have two reports running Count0To12Hr and Count12To24Hr both we the similar macros. Count0To12Hr works fine but Count12To24Hr still gives the same error - Subscript out of error.

What is the range of values that could appear in E2? -100 to 100
What is the range of values that you might put in iCount? -100 to 100

Now, I tried the scenario where iCount is -15 and the cell value is -10. It gives me an error at the below
olAttach.SaveAsFile tmpPath

Could you please advise.
Reply With Quote