Missing sent email messages in Apple Mail.
This morning I looked at Apple Mail on my Mac mini running Monterey 12.6 and found only half a dozen emails remaining in the sent folder since the middle of March. There are two from today, two in July and then all as normal from the middle of March going back. I have ten email accounts and sending email regularly, so this sudden loss of emails is baffling and obviously of concern.
Very strangely, if I search for specific sent messages I can find them, however they do not appear in the normal sent folders view. This suggests the issue is with the database in Mail and not related to the server. In any case this is affecting gmail, iCloud and a couple different web servers.
So far I have tried rebuilding all the sent email boxes inside Mail, then gone to the user library Mail folder to delete Envelope Index, Envelope Index-sim and Envelop Index-wal inside V9 > Mail Data. The next time Mail was started it went through a set up stage, which should have completely refreshed the database, however the issue remains.
Does anybody know how to fix this? All the accounts are IMAP and I must be missing hundreds of sent emails in the normal sent folders.
Thanks
Ashley
Mac mini, macOS 12.6