Re: $$Excel-Macros$$ Outlook and excel integration

2010-03-28 Thread Mahesh parab
Hi Putta F column contain passport expiry date, Formula in E column is F column date minus today's date in sheet1 code you will find below mention criteria, if column E value (No of days)more then 30 then email will get drafted. 'Above the MyLimit value it will run the macro MyLimit = 30 ch

Re: $$Excel-Macros$$ Outlook and excel integration

2010-03-28 Thread Puttaswamy
Can you please tell me how to work out this? I am bit confused. It would be great if you provide me the instruction. On Sat, Mar 27, 2010 at 1:29 PM, ~ Z A H E E R ~ wrote: > Thank you very much Mahesh. This is what i want. > > > On Wed, Mar 24, 2010 at 7:58 PM, Mahesh parab wrote: > >> Dear Za

Re: $$Excel-Macros$$ Outlook and excel integration

2010-03-27 Thread ~ Z A H E E R ~
Thank you very much Mahesh. This is what i want. On Wed, Mar 24, 2010 at 7:58 PM, Mahesh parab wrote: > Dear Zaheer > > I herewith attach sample sheet as per your requirement, u can read further > on below mention link, write back if u still find > any difficulty http://www.rondebruin.nl/mail/ch

$$Excel-Macros$$ Outlook and excel integration

2010-03-22 Thread ~ Z A H E E R ~
Dear Members, Is it possible to integrate MS Office 2007 and MS Excel 2007. For Eg. I have 1 excel file contains Employee ID, Employee Name, CID #, CID Expiry date, Passport #, Passport Expiry date, email My requirement : Whenever any employees CID or Passport is near to expiry date, outlook wi