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

gmayor · #1 03-24-2015, 11:04 PM

The Excel format is not the problem What are important are these three values, which must match the Excel file being processed.

Const strCell As String = "E2"
Const strWorkBook As String = "Count0To12Hr.xls"
Const strSheet As String = "Count0To12Hr"

Also change

Code:

lngCell = xlSheet.Range(strCell)

to

Code:

lngCell = Val(xlSheet.Range(strCell))

which should resolve the issue with negative values.

While testing make the Excel app visible so that if it does crash you are not left with a hidden Excel application.

Code:

xlApp.Visible = True

ketangarg86 · #2 03-25-2015, 07:11 AM

Now everything works as expected. Thanks a zillion Mr. Mayor

REALLY APPRECIATE your help.

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