Import email attachment(excel) to MS Access (1 Viewer)

[dj59]

· I have emails with excel attachments coming in multiple times a day to outlook.
· I want to click a button in Access and automatically import the last excel attachment in my email in box based on the timestamp of when it came in (thus getting the last one).

Does anyone know how this can be done?
Thanks.

 

[Rx_]

Use the ThenAMiricalHappens function? Ok, just kidding.

Actually, it will take a combination of Outlook then Excel automation.
It will require writing code, setting a reference in Tool Options to Outlook and Excel objects. Be sure to understand the basic concept of Early Binding.

http://www.btabdevelopment.com/ts/tq2xlspecwspath
This will give an example of Exporting data from Access to Excel.

Here are some examples to see how automation works.
http://www.access-programmers.co.uk/forums/showthread.php?t=250949
http://www.access-programmers.co.uk/forums/showthread.php?t=249670
http://www.access-programmers.co.uk/forums/showthread.php?t=249664
http://www.access-programmers.co.uk/forums/showthread.php?t=248093

What is your programming skill level?

 

[dj59]

After research I can see how this could be done....however I found a much simpler solution. We'll add a field to the user input screen and have the info we need....as usual I was making it harder than it had to be.
thanks for the information.

To be more clear....I discovered we only needed one field from the excel file, so easier to make that an input field.
Thanks again.