Import data from Outlook to table

[Lusitan]

Hello again.

I've been looking for an easy to use helpdesk DB and I found one on the Office templates site. (I've uploaded it here)

It's pretty simple but it suits my needs. I was wondering if someone can help with my question. How can I setup the DB that each time I open it, it transfers data from my outlook account?

Example: I have received some e-mails with some helpdesk request. For each new e-mail received, I need that, on the Case List table, one record is added with the information on the e-mail (time of record, subject,...). Hope it makes sense to you.

 

[spikepl]

1. You can link to the folder of your choice from Access. See External Data in your ribbon.
2. You can write some code in Outlook that automatically gets triggered by a rule set up in Outlook and then writes the body of the email, or extracted data, to an Access table, or triggers a function in Access, with the relevant data passed through the function header.
3. Or the Outlook code can be tied to a macro triggered by a user-defined key or added Outlook menu item.