Check for emails from a particular domain in outlook via VBA - MS ACCESS

What are you using to interact with Outlook?

Jim.

In Access: use External data \ More \ Outlook Folder.
then use a table data-macro or timer in Access to process new records.

In Outlook: code around the Application / ItemAdd event
e.g.
In this Visual Basic for Applications (VBA) example, when a new contact is added to the Contacts folder, the contact item is attached to an e-mail message and sent to a distribution list named "Sales Team". The sample code must be placed in a class module, and the Initialize_handler routine must be called before the event procedure can be called by Microsoft Outlook.

Public WithEvents myOlItems As Outlook.Items

 
Public Sub Initialize_handler()
 Set myOlItems = Application.GetNamespace("MAPI").GetDefaultFolder(olFolderContacts).Items
End Sub
 
Private Sub myOlItems_ItemAdd(ByVal Item As Object)
 Dim myOlMItem As Outlook.MailItem
 Dim myOlAtts As Outlook.Attachments
 Set myOlMItem = myOlApp.CreateItem(olMailItem)
 myOlMItem.Save
 Set myOlAtts = myOlMItem.Attachments
 ' Add new contact to attachments in mail message
 myOlAtts.Add Item, olByValue
 myOlMItem.To = "Sales Team"
 myOlMItem.Subject = "New contact"
 myOlMItem.Send
End Sub

Hi Jim

It is an Access 2016 front end with a SQL backend

What I meant was how you were tied to Outlook; using CDO, vbMAPI, Outlook Redemption, or just talking straight to Outlook with OLE and dealing with the security warnings.

As Coachman showed, you can work with Outlook directly, but most use a 3rd party product (which have their own object models) to avoid security warnings.

Jim.

Hi Jim
At this stage nothing is in place - it would be relatively easy using a direct link to an outlook folder with OLE.  The issue that I have is retrieving attachments with the mails

Many thanks Jim - all looks good - your solutions have always worked for me in the past