Range('email_Sender').Offset(i, 0).Value = OutlookMail.SenderName Range('email_Date').Offset(i, 0).VerticalAlignment = xlTop Range('email_Date').Offset(i, 0).Columns.AutoFit Range('email_Date').Offset(i, 0).Value = OutlookMail.ReceivedTime Range('email_Subject').Offset(i, 0).VerticalAlignment = xlTop Range('email_Subject').Offset(i, 0).Columns.AutoFit Range('email_Subject').Offset(i, 0).Value = OutlookMail.Subject If OutlookMail.ReceivedTime = Range('email_Receipt_Date').Value Then Range('email_Receipt_Date').Value = InputBox('Enter Receipt Date like 2') Set OutlookNamespace = OutlookApp.GetNamespace('MAPI')

I created the macro already for this But it does not export any data when I enter the date. When I run this macro for 23rd june it works fine.But when I run for 17th June date it is giving me data from 17th,22nd,and 23rd.same when I run 22nd june it is giving me 22nd and 23rd data.But My requirement is whenever I enter any specific date I should get only that particular date data.Not other other dates.

I have data for 17th June,22nd june and 23rd june in outlook folder. Allow some time for the re-index, as this is happening in the background, with no visible indication and the duration depends on the amount of content.Ī few hours should be about enough for a re-index and then try searching again.Thank you so much for your reply. See the following article from Apple to learn more: Ħ. Note: You must perform this step for any additional profile folders you may have. Once added, remove the folder from the same Privacy tab, and Spotlight will re-index the folder. Drag the ‘Main Profile’ folder to the Privacy tab. Copy and paste the following location into the 'Go to the folder:' dialog box and click Go:ĥ. Choose Apple menu -) System Preferences, then click Spotlight.ī. The key for me was Outlook had to remain open during the entire re-index of my profiles folder.

I was able to resolve this issue by Spotlight re-indexing the Profiles folder while Outlook is open. Files will be updated as the indexing goes on A new folder (rebuilding) will be created during this process. You can follow the re-indexing by looking at the same 'Main Profile' folder. This will force Outlook to re-index all messages, when you relaunch itīe patient, mine took 3 hours to re-index all my emails (important to plug in power and disable computer sleep in System preference) In the 'Main Profile' folder, move the 'Outlook.sqlite' to your desktop. The problem is probably due to an issue with Outlook index If not, try the methods mentioned above to force Spotlight to re-index the 'Main profile' folderĢ. Search with spotlight in this folder directly, if results are returned, then spotlight is working properly. ~/Library/Group Containers/UBF8T346G9.Office/Outlook/Outlook 15 Profiles/ Check if Spotlight indexing is working on the outlook folder I tried a lot of methods, this one worked for meġ.

Outlook for mac 2019 subfolder export