My department has a group calendar listing vacations, business, trips, etc., but people hardly ever look at it. Our department head wants an automated email going out to designated people telling who’s going to be out for the next several days, listing them by day, thusly:
1/1/1756
Person 1
Person 2
1/2/1756
Person 2
Person 3
…and so on. What I thought I’d do is use a modified version of the calendar view, listing only dates between now and seven days from now, then use an agent to rip through the viewentrycollection and construct a message body from its contents.
I’ve built a view that looks exactly right, but the problem I’m running into is the contents of the view entries. When you look at the view, you see the individual dates in the appropriate column (using @explode on the calendar doc’s start and end dates). Frex, when somebody is gone the 1st, 2nd, and 3rd, you see an entry for the 1st, another for the 2nd, and another for the 3rd. However, in the view entry collection, the correct number of entries is there, but the dates are different. Rather than having the 1st, 2nd, and 3rd, the column values in the NotesViewEntry objects are all the 1st. Moreover, the entry value is an array with one member for the first instance and a simple variant containing the value for the others. The 2nd and the 3rd don’t appear. Can anybody tell me what’s up with that? Is there some much easier way for me to be doing this?