Office Solutions

How to Extract & Show All Hyperlink Addresses in an Email via Outlook VBA

Most of time, to view the hyperlink addresses, you need to hover the cursor over the displaying text. This article will teach you to use VBA to show all the addresses in one email simply by one click. As you know, apart from directly adding a URL in the email body, you’re allowed to insert hyperlink to texts. In this case, you will be unable to view the hyperlink addresses straightly. You need to hover the cursor over the displaying text. But, it will be quite tedious if there are too many...

Read more »

2 Ways to Quickly Get the Alternative Texts of Pictures, Shapes, Tables, Charts, SmartArt Graphics, or Other Objects

In this article, we will exhibit you 2 ways to quickly get the alternative texts of pictures, shapes, Tables, charts, SmartArt graphics, or other objects in Word document. Sometimes, objects like shapes, pictures inserted into your document contain alternative texts. They help to explain the details of an object. However, these texts do not show themselves directly. Instead, you have to right click on an object. And choose “Format Object” to open “Format Shape” box. Next click “Alt...

Read more »