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...
Read more »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...
Read more »Where data downloaded from a database exceeds a combo box’s range, the new items are simply not shown. To counter this, the range that underlies List or Combo boxes needs to expand or contract to match the data. This article examines how to do this...
Read more »In this post, we are glad to show you 3 effective methods to batch remove the fill color of multiple shapes in your Word document. While inserting shapes into a Word document, you may apply fill color to them as well. It’s easy to add or remove...
Read more »In this article, we would like to exhibit you 3 quick ways to remove hyperlinks from pictures in your Word document. Sometimes, when copy a picture online, we find it embedded with a hyperlink. And in a Word document, accidentally clicking on...
Read more »Many users hope to configure their Outlook to keep the original email attachments when replying an email. This article will expose 5 workarounds as well as a smart way, which is using VBA to realize it automatically. I have heard a great number...
Read more »If you would like to quickly export the folder structure of your Outlook data file to an Excel workbook, you can utilize the method introduced in this article. For some reasons, such as logging current Outlook folders and subfolders, many users...
Read more »In this article, we will focus on demonstrating you 3 useful methods to batch clear all table styles in your Word document. Every once in a while, if a Word table is applied with an undesired style or it reduces the visual effect of the entire...
Read more »If you have configured several email accounts in your Outlook and would like to use different fonts in outgoing emails as per different email accounts used for sending, you can utilize the approach introduced in this article. Many users hope that...
Read more »In this post, there are 4 effective ways you can deploy to copy or print the outline of your Word document. Now and then, we would need to share with teammates the progress of a project. For example, it’s common to send between each other the...
Read more »