Office Solutions

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 »

How to Quickly Resend the Meeting Invitation to Those Haven’t Responded in Outlook

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

Read more »