File Recovery

2 Methods to Auto Set the Status of All Day Event to “Busy” in Your Outlook

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...

Read more »

How to Call a SQL Server Stored Procedure from Excel VBA

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...

Read more »

How to Get Warned If There Is Not Enough Free Time between Outlook Appointments

In order to keep your schedule not too hasty, you had better keep enough free time between Outlook appointments, such as at least 30 minutes. Now, this post will let your Outlook to warn you if there is no enough free time between appointments. Unquestionably, you should make your schedule reasonably. One of the most vital rules is to keep enough free time between appointments, preventing making your schedule too hasty. Otherwise, you will find that, most of time, you may miss or can’t...

Read more »