How to Auto Monitor the Changes of Port Numbers for Multiple SQL Servers

If there is a change in the SQL Server's port number, connections will fail. In order to avoid this, it is a good practice to proactively monitor SQL Server's port number and act on non-compliance. Monitoring SQL Server's port number is important. So in this article, we would be learning to automate it. TCP/IP – A universal method The TCP/IP is a universal network protocol that is used to connect to a SQL server instance. When the port number of SQL Server is changed, application connected...

Read more »

How to Auto Color Categorize Outlook Emails based on Whether Senders are Known or Unknown

If you want to distinguish between the emails from known and unknown senders by color categories, you can use the means introduced in this post. It will use Outlook VBA to auto color categorize the incoming emails based on the senders. As we all know, Outlook comes packed with a native classification feature - Color Categories. Undoubtedly, it indeed plays a good role in managing and organizing a great amount of Outlook items, such as myriad emails. Therefore, many people prefer to use this...

Read more »

How to Find and Replace Contents in Multiple Word Documents

In today’s article, we are thrilled to inform you of the way to find and replace contents in multiple Word documents. Generally speaking, most Word users are quite familiar with the “Find and Replace” feature in the software. It helps us with the batch process through the entire document, which saves us a lot of time. Then have you thought about using this option in multi-document, like all files under a specific folder? Since there is always the need to search and replace contents...

Read more »