File Recovery

How to Quickly Find out All Other Appointments Conflicting with a Specific Appointment in Outlook

When you create or change an appointment in Outlook calendar, Outlook will auto check if there are any conflicting appointments. At this time, if you wish to check the conflicts, you can use the method introduced in this post. Perhaps you have ever seen the “Conflicts with another appointment” text when creating or altering an Outlook appointment. It’s because that Outlook can auto check the conflicts. However, Outlook cannot help you to find the conflicts quickly by its default...

Read more »

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 »