Office Solutions

How to Auto Update the Date in Subject when Forwarding or Replying an Email in Outlook

If you always want to ensure that the latest date is inserted into the subject no matter when forwarding or replying an email, you can use the way introduced in this post. It will auto update the date that has existed in the subject to the current date. By the means introduced in my previous article - “How to Auto Insert Current Date into the Subjects of Incoming Emails with Outlook VBA”, each incoming email’s subject will always contain a date. In this case, when you forward or reply...

Read more »

5 Methods to Quickly Apply the Fill Color of a Table Cell to the Whole Row, Column or Table

In this article, we will offer you five methods to quickly apply the fill color of a table cell to the whole row, column or table. You might notice that when you do copy in a table cell in Word, you get only the cell content but never the fill color. Therefore, we want to show you five workarounds to address this issue.     Method 1: Manually Get the RGB Value of Table Cell First of all, select the cell whose fill color you need to get. Next click “Design” tab. Find the...

Read more »

How to Auto Insert Current Date into the Subjects of Incoming Emails with Outlook VBA

If you always want to insert the current date into the subjects of incoming emails as they land into your local mailbox, you can utilize the VBA code introduced in this post. My previous article “How to Auto Insert Current Date or Time into Email Subject or Body with Outlook VBA” has taught you to insert the current date into email subject when you’re composing an email. Similarly, many users wish that Outlook can auto insert the current date into the subject of incoming email as they...

Read more »