Open an Excel file based on subject heading of an email

  • Thread starter Thread starter Jamie
  • Start date Start date
J

Jamie

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
 
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
 
Back
Top