Outlook Email

[bupton]

I am wanting to watch an email folder in OutLook and then write certain data into my database. not sure where to begin.

Thanks Brian

 

[jhall156]

In whatever code module you want to work, Tools|References select the Microsoft Outlook Object Library

Then in your code you can use all those cool outlook objects.

If memory serves...

Dim Outlook As Outlook.Application
Dim MyNS As Outlook.NameSpace

Set Outlook = New Outlook.Application
Set MyNS = Outlook.GetNameSpace("MAPI&quot

etc.

Check out in your Outlook help files under Advanced Customization|Microsoft Outlook Visual Basic Reference|Microsoft Outlook Objects for a map of the Outlook object hierarchy. JHall

 

[bustell]

Try this Microsoft Office developer forum:

http://www.microsoft.com/accessdev/articles/OutProg.htm

Pat B

 

[B827]

For Access97 there is a down loadable wizard to link Outlook to Access. This is very useful as you can link outlook Inbox as an Access table.

Article Q176702 gets the download. I assume there is something similar either already in the later versions or available as a download. Sandy

 

[lxn]

Hi, exactly what kinda data do you want and from which email folder? If it's something like Address book, or contact folder and such, then what JHall suggested is the way to go, if it's something like each email in the inbox, their attachments and stuff like that, then I think the .ActiveInspector property works great. I don't know exactly what you are trying to do, if you could be more specific, maybe I can help a bit more.
k, I just realized that the initial post was made 10 days ago, so I'm guessing that you've already had this resolved, this is just in case you are still having trouble then