How to Using Excel to Read and Write an External Database

Excel can do virtually anything; whether it should be made to do everything is another matter. While the spreadsheet is very powerful in manipulating data, it isn’t too great at storing normalised data. Harnessing Excel to a relational database like SQL Server enhances the application’s power. To start with, you will need MS Access or the more stable and free - SQL Server Express. It is assumed that the reader has the Excel Developer ribbon displayed, and is familiar with the VBA Editor...

Read more »

How to Auto Move the Tasks Assigned to Others to a Specific Task Folder in Outlook

In general, all the tasks will be placed in the default Outlook task folder, no matter your won tasks or the tasks which you assign to others. This article will introduce how to make Outlook to auto move tasks assigned to others to a specific task folder. Outlook permits us to assign tasks to others. But in the meantime, the tasks that you assign to other people will be saved in your default task folder as well. In this case, if you often need to assign tasks to others, your task folder will...

Read more »

5 Methods to Configure Outlook Not to Send out Emails Directly

Some users hope that they can control Outlook’s sending feature, namely prevent emails from being sent out directly when they click the “Send” button. In this article, we will introduce 5 approaches. At times, after you click the “Send” button, something else comes to your mind. For example, you want to add an additional attachment, or you wish to rephrase the email, and so on. All in all, in such cases, you will desire that Outlook won’t send emails directly or automatically...

Read more »