You may want to write this macro in Outlook VBA and have every thing
automated. You can hae outlook VBA filter you emial and when an email
with a specific Subject line is received run a Macro in Outlook which
will have your user access priviledges. the outlook VBA can open an
excel workbook(s).

The Outlook VBA will take the incoming email and same the workbook in
one of your folders. then open the workbook and add the new data to
your existing workbook.

You can also have Excel VBA search you outllok folder for specific
subject lines and take those emils and save the attachments into a
folder and then add the new lines from the updated workbooks into your
master workbook.

I have written both type macros before and can find code once you come
up with your preference.

filtering on a subject line in VBA code (both outlook and excel)
requires doing a search of your emails which requires a class module
in VBA.

The easier method would be to manually add a task to your outlook email
account which saves emails with a specific subject line to a outlook
folder. then the VBA code won't have to do the search.

Again if you want to some manual operations you can simply manuall save
the outlook emails to a PC folder and then your VBa macro just as to
open all the files in the PC folder and add the new lines.

The are lots of method to automated and semi-automate this process.
Just rember VBA code can access your email and open workbooks either
from Excel VBA or Outlook VBA. You can even set up a schedule event on
your PC which will run an Excel VBA macro. The advantages of running a
macro in Outlook is that your PC doesn't have to be on for an event to
run, while a PC schedule event your PC needs to be running.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=183137

Microsoft Office Help