"Live, Learn, Apply & Educate!": March 2014

Monday, March 17, 2014

Microsoft Outlook: Auto Archive in Outlook 2010

Step 1: From the main screen of Outlook, Choose File/Options.

Step 2: From the Outlook Options screen, choose Advanced.

Step 3: From the Outlook Options screen, choose AutoArchive Settings button from the right hand pane.

Step 4: Configure the following key parameters: Run AutoArchive every and Clean out items older than. Note: Only select the button Apply these settings to all folders now if you want every folder on your mailbox to be set to auto archive. If you do not, you will need to set the auto archive configuration manually on each folder. Click OK

Step 5: From the Outlook Options screen, click OK.

Step 6: If any new folders are created after applying the default settings, modify the folder properties on the AutoArchive tab of the new folder. Select the radial button to the left of “Archive items in this folder using the default settings”, then click OK.

Microsoft Excel: How to select all objects (pictures and charts) easily in Excel?

Select all objects in active worksheet
You can apply the Go To command to select all objects easily. You can do it with following steps:
Step 1: Press the F5 key to open the Go To dialog box.
Step 2: Click the Special button at the bottom to open the Go To Special dialog box.
Step 3: In the Go To Special dialog box, check the Objects option.

Step 4: Click OK. Then it selects all kinds of objects in active worksheet, including all pictures, all charts, all shapes, and so on.

Select all pictures in active worksheet

It seems no easy way to select all pictures except manually selecting each one. Actually, VB macro can help you to select all pictures in active worksheet quickly.

Step 1: Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.
Step 2: Click Insert > Module, and paste the following macro in the Module Window.

Public Sub SelectAllPics()
ActiveSheet.Pictures.Select
End Sub

Step 3: Press the F5 key to run this macro. Then it selects all pictures in active worksheet immediately.

Select all charts in active worksheet

VB macro can also help you to select all charts in active worksheet too.

Step 1: Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.
Step 2: Click Insert > Module, and paste the following macro in the Module Window.

Public Sub SelectAllCharts()
ActiveSheet.ChartObjects.Select
End Sub

Step 3: Press the F5 key to run this macro. This macro will select all kinds of charts in active worksheet in a blink of eyes.

Monday, March 10, 2014

HTML: Mailto Body Formatting

If you would like to embed your desired Subject line and sample message body from mailto/hyperlink, see a sample below:

mailto:someone@domain.com?subject=Subject%20Line&body=Sample%20message%0D%0ANext%20line