By default, the status of all day event is “Free”. But in reality, we commonly hope to set the status to “Busy”. Therefore, this article will show you 2 approaches to realize it.
Many users are annoyed at that Outlook show all day event as “Free” by default. Thus, they have to manually change the status every time when creating all day event. Undoubtedly, it is pretty troublesome. Hence, here we will introduce 2 tips to auto set the status of all day event to “Busy”.
Method 1: Design a...
Read more »
Data on a server can be modified by examining the records ‘client-side’ in Excel VBA, changing them as required, and saving them back to the server.
A more efficient way of doing this, particularly if the database is at a remote location and there’s a lot of traffic involved, is to do the work ‘server-side’. This exercise calls a stored procedure from Excel to categorise employees into age-ranges according to their dates of birth (i.e. 18-25 years, 26-35 years, etc.), without a copious...
Read more »
Many users hope to quickly resend the meeting invitation to the attendees who have not made any responses. This article will show you how to achieve it.
In my previous article – “How to Quickly Send a Notification Mail to the Meeting Attendees Who Haven’t Responded”, you could learn how to send a notification mail to the meeting recipients who haven’t responded. Similar to it, many users would like to directly resend this meeting invitation instead of a notification mail. Thus, in the...
Read more »
