Using a mail message to open and modify a spreadsheet

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
 
M

Michael Bauer

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

Selecting Spreadsheet Cell Information for e-mail 2
Open attachments and run macros? 1
Open an Excel file based on subject heading of an email 1
Attachments 1
Find a String in Email Attachment(s) 1
Automatically save attachment 1
Automatically email an Excel file to a Distribution List 1
Open specific hyperlink (accept) automatically in email with outlook 0

Top