Previous Thread:   Deleting items in public folder

9/27/2005 10:04:46 AM    Open an Excel file based on subject heading of an email
Hi There  
  
I am trying to find some VBA code that will open a particular file  
  
(i:/eis/forms/job log test.xls) if I receive an email with the subject  
  
heading "EIS_Request".  
  
If anyone can help I would greatfully appreciate it.  
  
Thanks in advance  
  
Jamie



9/27/2005 8:57:16 PM    Re: Open an Excel file based on subject heading of an email
Am 27 Sep 2005 10:04:46 -0700 schrieb Jamie:  
  
Jamie,  
  
please use the ItemAdd event of the Inbox. That events fires if an  
  
e-mail is coming in. You can then check the Item´s Subject property. if  
  
it matches your criteria then use the Workbooks.Open method.  
  
All mentioned methods, events etc. are explained with samples in the VBA  
  
help  
  
--  
  
Viele Gruesse / Best regards  
  
Michael Bauer - MVP Outlook