• 0

Outlook VBA Sort by Date


Question

I am building a code that does a search in a Outlook folder and put the body of the items together in just one item (to build a history for that case).


I am performing the search using the Find method (not sure if all correct). Once I get the search results, I'll put them in an array.


Is there a way to sort the array by date? I keep getting an error with code below:



Dim olApp As Outlook.Application
Dim olNs As Outlook.Namespace
Dim olFldr As Outlook.MAPIFolder
Dim olItms As Outlook.Items
Dim olMail As Variant
Dim MyArray() As String


Set olApp = New Outlook.Application
Set olNs = olApp.GetNamespace(?MAPI?)
Set olFldr = olNs.GetDefaultFolder(olFolderInbox)
Set olItms = olFldr.Items


Set olMail = olItms.Find("[Subject] = ""*140115LS*""")
If Not (olMail Is Nothing) Then

MyArray = olMail.Display

Link to comment
https://www.neowin.net/forum/topic/1198807-outlook-vba-sort-by-date/
Share on other sites

1 answer to this question

Recommended Posts

This topic is now closed to further replies.
  • Posts

    • True they were Inspiron models and Dell's SupportAssist has a long history of security vulnerabilities. I also had problems with Dell System Detect and the Dell Software Update utility program. It was all way too much trouble. So I just removed all of them and manually did updates from their website but that was also a pain. Overall, the Inspiron's were decent enough until one became unusable for Windows after a malware attack. I Installed Ubuntu on it and used it with Ubuntu for several months before giving it away.
    • You can now turn 2D images into 3D objects with Copilot's new feature by Taras Buria Copilot Labs, a section with various experimental features in Microsoft's AI assistant, received a new feature called Copilot 3D. With this feature, Copilot lets you transform 2D images into usable 3D objects. Microsoft wants to simplify the process of creating 3D models, giving users a useful tool that has no steep learning curves and does not require installing complicated software. With Copilot 3D, users can transform images into 3D models for later use in game development, animations, 3D printing, design, AR or VR content, art projects, and more. Additionally, users can browse a library of various 3D objects and scenes for inspiration, which sounds awfully familiar to the now-deceased Paint 3D and its content marketplace. Copilot 3D is a one-click solution. All you need is to upload a picture (PNG or JPG, less than 10MB) and wait for Copilot to do its job. Unfortunately, Copilot cannot generate 3D objects from text prompts, at least for now, as Microsoft says in the announcement article. Copilot 3D is available for free globally to a subset of Copilot users, but you need a Microsoft Account to access it from the browser. Once your object is generated, you can download it in GLB format so that you can later modify it in any compatible 3D viewer, editor, or game engine. Microsoft also adds that all creations are stored for 28 days, and the company does not use the uploaded images for model training or personalization. In case you missed it, Microsoft recently introduced another Copilot Labs feature, which gives the assistant a physical appearance with physical expressions and emotions for a more natural conversation in Voice Mode. Also, Microsoft launched Gaming Copilot in Game Bar so that AI can see what is going on on the screen and give you tips, suggestions, and other useful information.
    • Shou Zi Chew was Xiaomi's CFO for five years and was with them when they were blacklisted by the first Trump administration. Xiaomi was subsequently removed from the blacklist by the Biden administration. Sen. Cotton was also a Senator when Xiaomi was blacklisted though I don't recall if he was influential in bringing about the blacklisting.
  • Recent Achievements

    • One Month Later
      Jaclidio hoy earned a badge
      One Month Later
    • Week One Done
      Yawdee earned a badge
      Week One Done
    • Week One Done
      eugwalker earned a badge
      Week One Done
    • First Post
      Ben Gross earned a badge
      First Post
    • One Month Later
      chiptuning earned a badge
      One Month Later
  • Popular Contributors

    1. 1
      +primortal
      634
    2. 2
      +FloatingFatMan
      174
    3. 3
      ATLien_0
      139
    4. 4
      Xenon
      118
    5. 5
      wakjak
      108
  • Tell a friend

    Love Neowin? Tell a friend!