[AccessD] Outlook Automation

Kath:

I thought I remembered something from a few days ago.

Yes, I'd appreciate that piece of code.  I got as far as:

   Dim appOutlook As Outlook.Application
   Dim msgOutlook As Object
   Dim nSpace As Outlook.NameSpace
   Dim folderOutlook As Outlook.MAPIFolder
   Set appOutlook = CreateObject("Outlook.Application")
   Set nSpace = appOutlook.GetNamespace("MAPI")
   Set folderOutlook = nSpace.GetDefaultFolder(olFolderInbox)

Will this do it?  I have to ask the client if I'm to look in the Inbox 
or if he's directing mail from a certain address into another folder.  I 
assume there's a way to look at the "To" field to see if it's addressed 
to the mailbox in question.  So I guess I have to figure out the object 
model.  And the For Each loop to look at each item int he mailbox.

Thanks and regards,

Rocky


Kath Pelletti wrote:
> Rocky - in the post I sent you a couple of weeks ago the code looks for a specific folder within Inbox. If you need the code again, let me know. If you need to reference a difft. mail folder then I don't have that but maybe you can tweak it?
>
> rgds
> Kath
>   ----- Original Message ----- 
>   From: Rocky Smolin - Beach Access Software 
>   To: Access Developers discussion and problem solving 
>   Sent: Friday, June 02, 2006 1:47 PM
>   Subject: [AccessD] Outlook Automation
>
>
>   Dear List:
>
>   I need to look in a specific outlook folder for mail.  I can't find the 
>   syntax for this.  Can anyone point me in the right direction?
>
>   MTIA
>
>   Rocky
>
>   -- 
>   Rocky Smolin
>   Beach Access Software
>   858-259-4334
>   www.e-z-mrp.com
>
>   -- 
>   AccessD mailing list
>   AccessD at databaseadvisors.com
>   http://databaseadvisors.com/mailman/listinfo/accessd
>   Website: http://www.databaseadvisors.com
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com