That is just Brilliant, OBP! I love how fast it runs!

Unfortunately, the ordering is not quite right, but this is still a HUGE step in the right direction!! I appreciate all the work you put into this, little did I realize you would go through and completely redo the VBA to use a different, clearly more efficient, method. I can't wait to get it tuned to concatenate properly and use it on the 2 year span of data, and then in the larger weekly/monthly reports.

For some reason the sort order is all over the place, I see what you were saying now. The team should go first, followed by a :, and the agents on that team (separated by commas), then a period between each team. Any users CC'd (email addresses) should go to the end of assignee. Perhaps this could be accomplished through different ordering and some form of looping.

Is it possible to make this type of script run off a single query, or does it have to be completed through a form? The reason I ask is because it will represent 1 field in a larger set of data that makes up the reports. It would be easiest if it didn't have to be updated separately from when the main report is ran, as an extra step. I assume the precautions of verifying data deletion cannot be bypassed in Access?

I will take a more thorough look through your scripts tomorrow!

Thank you once again, sir; you are a gentleman and a scholar!!

Sincerely,
Kris Penland