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.
 

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

Access Automatically Send a notification email once a record is added 0
Selecting Spreadsheet Cell Information for e-mail 2
Last Modified By in a cell by user 3
Repetitive mailings-different subjects/attachments 2
Send a reply on opening an email 1
How to convert email to task on an OPENED EMAIL, pls? 2
Delete message after sending 2
Open attachments and run macros? 1

Back
Top