Outlook macro to check a value of a cell in an attachment and send an email based on that value

ketangarg86 · #11 03-24-2015, 08:56 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create macro program to automatically email outlook with a visible cell range	BillMaintenance	Excel Programming	19	03-11-2015 03:19 PM
Can anyone here tweek this macro for renaming Excel files based on a cell's contents?	chrisd2000	Excel Programming	6	07-01-2014 01:53 PM
Email alert based on value in cell	sweetcuda	Excel	0	03-12-2014 12:44 PM
Command button - save in temp folder and send email with attachment	bigbird69	Word VBA	13	11-18-2012 10:06 PM
Macro based on cell value	ubns	Excel Programming	1	05-07-2012 04:03 AM