Searching Sent Items

[DMT Dave]

Hi Guy's we have a booking form that comes through an outlook inbox, sometimes we may need to see what was actually sent, we are not saving the sent mails to an office database whereas we do save on the laptop so we can work remotely.

Can i pull a string from the booking form ie:

Title:
Forename:


Surname:
Postcode: abcdef (Inbox mail body)
Etc:
Etc:

Refresh a list that has conversations that would correspond with that postcode in (Sent Items)

??

Thank you

[DMT Dave]

Hi Guys, this opens up the sent items folder, how can i add a criteria in sent items to a specific email address so the sent items displays all emails for that email address ?

Dim olApp as Object, olNS as Object, olFldr as Object
Set olApp = CreateObject("Outlook.Application")
Set olNs = olApp.GetNamespace("MAPI")
Set olFldr = olNs.Folders("Ouremail address.com").Folders("Sent Items")
    With olFldr
    .Display
    End With

[Micron]

Don't know, but sometimes with these questions I do a little Googling just in case I come across a need in the future - not that I expect I'll ever really use it. It seems that you need to filter on a field (column), which in your case would likely be recipient or sender?

Look most of the way down here for this paragraph

This Visual Basic for Applications (VBA) example uses the Restrict method to get all Inbox items of Business category and moves them to the Business folder. To run this example, create or make sure a subfolder called 'Business' exists under Inbox.

[Welshgasman]

Amend the code from this link?

https://learndataanalysis.org/proper...n-outlook-vba/

[DMT Dave]

Thank you guy's will have a study and see where i can get to

[Micron]

@Welshgasman, BTW, that bold stuff was just copy/pasting. I've not taken up that habit of bolding every other word!