3 Effective Ways to Extract Cell Texts Only from Your Word Table

In this article, we would like to show you 3 methods to extract only the cell texts while coping from a Word table. Every time in the intention to copy texts from a Word table, it’s easily to select the entire cell. Thus, when we paste cell texts somewhere else, the cell borders are very much possibly go there too. Without much to say, cell borders are not favored in such case. Therefore, it’s necessary to eliminate them. Then the first thought that could strike to our mind may be to make...

Read more »

How to Auto Save Specific Sent Emails to a Specific Folder with Outlook VBA

By default, Outlook will save the sent emails in the “Sent Items” folder. If you don’t want to save the specific sent mails in the default folder, you can employ the method introduced in this article. Some users want to automatically save some sent emails to the specified folder instead of saving them in the default “Sent Items” folder. Thus many resort to the Outlook rule, which offers a similar action – “move a copy to the specified folder”, shown as the following screenshot. However, by...

Read more »

How to Display Multiple Results in a Single Query Field in Your Access

If you’ve ever needed to produce a delimited list of field/query values alongside other information from your database you’ll know it can be challenging at best – and a task most people think isn’t going to be possible. If, for example, you’ve been asked to produce a report of how who were the top 5 sales people – in Descending order – for each month of the year, or the closest 3 stores to each customer, then you’re potentially left with wrangling with crosstab queries or manually combining the...

Read more »