Office Solutions

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...

Read more »

How to Control Data Capture with a VBA Form in Excel

User capture into a spreadsheet is difficult to police; the entry point could be anywhere, and even locking of some cells provides no focus on the part of the user. A User Form with validation can provide an orderly channel for data capture into a spreadsheet. The article assumes the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google “Excel Developer Tab” or “Excel Code Window”. Objective To produce the following form, which writes...

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...

Read more »