Using a mail message to open and modify a spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi There

People send me information requests via email on an excel spreadsheet. I am
looking for a way to log these requests. I was wondering if there is anyway
I can write a piece of code that, on receipt of an email with say 'Request'
in the subject line, it would automatically open the attachment and run a
macro from within the attachment?

Any help would be greatfully appreciated.

Thanks in advance

Jamie
 
Hi Jamie,

you can use the Inbox´ Items´ ItemAdd event. Please see VBA help for a
sample. In this event save the attachment to the filesystem and then use
the Excel object model for opening that file.
 
Back
Top