Hi, i am a vba total noob and am looking for a way to assign a category to a set number of emails in outlook as a way of allocating work.
The categories are all set up for each person, and i will have an excel file that has the categories and how many emails to assign for each person.
The mail folder will change and need to be selected. The number of emails assigned to each category will be different each time as it is based on work hours.
This would need to be run on multiple days, having any email that already has a category ignored.
When it runs out of emails i want it to present the person it was up to and how many remaining to be allocated
My data will look something like this
outlook category surname first name logon number to allocate
john smith smith john abc123 7
betty jones jones betty bcd124 5
Appreciate any help
The categories are all set up for each person, and i will have an excel file that has the categories and how many emails to assign for each person.
The mail folder will change and need to be selected. The number of emails assigned to each category will be different each time as it is based on work hours.
This would need to be run on multiple days, having any email that already has a category ignored.
When it runs out of emails i want it to present the person it was up to and how many remaining to be allocated
My data will look something like this
outlook category surname first name logon number to allocate
john smith smith john abc123 7
betty jones jones betty bcd124 5
Appreciate any help
