Transfer spreadsheet automatically

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

Guest

Hi all,

Once a month I get the same e-mail from lots of different companies. The
e-mail has an .xls attachment. I know how to strip the e-mail of the
attachment automatically and then manually load it into a local access
database.

Is there away of instead of stripping the .xls file it can be automatically
loaded into a local access database directly from Outlook 2003.

The .xls file will have the same row headers, just different data.

I think I need to use the docmd.transferspreadsheet, but I am getting lost!!

Many thanks for you help
 
Attachments can only be manipulated after you save them to the file system.
 
You must log in or register to reply here.

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

Which is the best MBOX Converter Tool different formats conversion? 4
Automatically save attatchment with a different extension 1
Recursively process message attachments 1
Outlook + Excel 2
Sending MSG attachments as new emails 0
OL2007: Application_Startup event 2
importing across applications 4
SAVE A .csv ATTACHEMENT AS A NETWORK .xls FILE 1

Back
Top