Open an Excel file based on subject heading of an email

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
 
M

Michael Bauer

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Excel Worksheet 1
Read email body and move values to excel sheet 0
VBA to send files in folder 1
edit selected subject line of already opened email message 0
Export text in an email to excel 1
Open a Dynamic URL on Receipt of an Email 0
Using a mail message to open and modify a spreadsheet 1
Find, Copy, Sort, Forward, Add Text - COMPLICATED! 1

Top