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
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