Office Solutions

How to Batch Extract the Texts of All Tables in an Outlook Email

It is easy to convert a table to text, extracting the texts of a table. However, if you want to extract the texts of all tables in one go, you can use the way introduced in this post. In my previous article “How to Convert Between Text and Table in Outlook Messages”, you can learn the standard way to convert a table to text. There is no denying that it is simple. Nevertheless, if a mail contains multiple tables and you wish to convert all of them to text, using that way is a bit...

Read more »

How to Quickly Export All Tables in an Outlook Email as Pictures

Some users would like to extract the tables in an email and save them as pictures in a Windows folder. Obviously, Outlook doesn’t have such a function. But it still can be realized by means of VBA code. This article will show the details. If you want to extract the tables of an Outlook email and recycle them, you could export and store them as pictures on a local drive. Yet, there is not such a native function in Outlook. Therefore, if you want to achieve it, you can use the following way,...

Read more »

Why One Should Avoid Using Memo Fields for Grouping in Access

In this article we would learn the key aspects related to memo fields and learn why they are not really helpful and often result in bugs and truncation. A memo field can store large amount of information, allowing up to 65,536 characters, with various options. In the latest editions of MS Access, it can store up to 1 GB of characters and allows rich text formatting. But it is often suggested to avoid the use of Memo fields for purpose like grouping in MS Access. The article will discuss the...

Read more »