Linking an Outlook Inbox to a Table in Access 2007

[Lateral]

Hi guys

I'm a newbie and have been maintaining and enhancing an existing database in Access 2007.

I need to "link" an Outlook Inbox to a table so that I can search and find emails belonging to a specific customer when required.

I cannot use the "External Data" functionality as I keep getting the following error message:

Object or Class does not support the set of events

I have spent many many hours Googling and searching numerous forums to solved the error to no avail.

I decided to take a different approach and to try to use VBA code within Access to do what I need to o.

I found the following code that enables me to read the Outlook Inbox but that's about it.

Set golApp = Outlook.Application
Set gnspNameSpace = golApp.GetNamespace("mapi")
Set MAPIFolder = gnspNameSpace.GetDefaultFolder(olFolderInbox)
For Each Item In MAPIFolder.Items
MsgBox Item.Subject
Next

So, my question is this, can somebody please provide me with VBA code to enable me to "link" an Outlook Inbox to an Access 2007 table?

I will be forever grateful!

Thanks for any help you can provide.

Regards
Greg

 

[Lateral]

Come on guys.....I need some help...don't let me down...

 

[spikepl]

You have demanded "provide me code" - I , and presumably others, read it as if we are to do the work for you. This is a volunteer forum HELPING people for free, but not doing work for free.

Buy some programming assistance or show willingness to do it yourself. In the latter case there are millions of examples of how to get data from emails, also on this site, so you seriously need to polish your google skills.

As a freeby I can tell you that linking to an inbox is a pretty lousy idea: most peoples' inboxes are phenomenally huge, since few clean them up, and so link at start up takes ages. Open outlook as in your snippet and get the mails from there. Google.

 

[Lateral]

Thanks Spike,

I apologize if it sounded as if I wanted somebody to provide me with something for nothing....that was definitely not what I wanted.

It's just that I have spent many many hours trying to figure this issue out by Googling, searching numerous forums and trying to figure it out myself but I'm stuck and was hoping that somebody on this forum would provide some help.

I have used this forum over the years only after I have spent a lot of time first trying to figure out stuff myself.

Sorry again if I offended anyone.

Regards
Greg

 

[GaryPanic]

This is something I thought that I would like - and then had a re-think on it
as pointed out. most inbox's are a nightmare - There are some who tidy up after themselves -
better route would be move the email from that persons and drop it in to a folder that relates to that person


- I do this on a quote number - (insurance)
create quote number (mk Dir on this number)
all emails (from system have this in the subject line - say your quote 12345
or your cover note 12345 - your renewal 12345 ... and after i have sent the email I drag a copy in to the folder -

as the email comes in I drag it in to the right folder
then its one folder per quote number .

this means that anyone can see the email trail - start to finish (and given that 95% of enquiries are email ..) those that are "paper" then get scanned in to their folder

seems to work and does not involve a lot of extra work

while not an answer to your problem - it might be a solution to a re-think on how you work ??

hth

 

[Lateral]

Hi Gary,

The process I currently have flows as follows:

1. Customer creates a shopping cart on the website.
2. An email is send to me containing a list of products that the customer wants.
3. The email is placed in an Outlook folder called "Shopping Cart Orders" via a Rule
4. I read the email and then check to see if I have everything in stock etc.
5. I open my Access 2007 database that I use to generate the actual invoice. This database also contains a table of all of the products that the are available on the website.
6. I build an invoice by selecting from the table as mentioned in step 5. There is other pieces of information that I also need to copy and paste from the email in the Shopping Cart folder. (ie: Customer name and address details etc)
7. I then email the invoice to the customer.

I would like to import or directly connect to the folder so that I can automate the generation of the invoice.

Regards
Greg