Sorting Outlook Emails with Access - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Sorting Outlook Emails with Access

Kevin Willyerd

47 days ago

I receive over one thousand emails daily, (I know, but what is is). I have a program that runs from Sperry software, which sorts the email according to rules for me. It is an XML file and seems to get corrupted on a semi-regular basis. I was wondering if it would be possible to create an access program that would do the same sorting.

As a secondary question, how does everyone else handle the auto-sorting of their email when Outlook rules are limited and won't handle the volume?

	Alex Hedley @Reply 47 days ago
What makes them limited and unable to handle the volume? Are these in an enterprise account? Manage mail flow rules in Exchange Online https://learn.microsoft.com/en-us/exchange/security-and-compliance/mail-flow-rules/manage-mail-flow-rules

	Kevin Willyerd OP @Reply 42 days ago
I had been trying to use the rules directly in my desktop Outlook, and that limited the number. I was not aware of the exchange option that you pointed out. I will give it a try. Thank you so much.

Kevin Willyerd OP @Reply

42 days ago

Most of the rules I use are simple: if xxx is in the sender, move the email to folder yyyy. The Exchange Server does not have an option to move the email from the inbox to a subfolder that I can find. I have over 3000 rules. Outlook has a limit of 256k (about 80-100 rules). But it does let me move them to a subfolder. That is why I have been using a third-party add-on. It uses an XML file that has been corrupted on a regular basis lately, as the file size has increased.

	Alex Hedley @Reply 42 days ago
https://learn.microsoft.com/en-in/answers/questions/5778207/exchange-admin-center-why-can-t-mail-flow-rules-mo

	Kevin Willyerd OP @Reply 42 days ago
ALEX, Thank you for the definitive answer. I now know why. How difficult would it be to create a system that would work in Access? If it worked for a small number of rules in XML, it makes sense to me that it could be written in VBA with a SQL backend. What do you think?

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View