Wednesday, March 30, 2011

Word: Dropped Capital

To create a big letter at the beginning of a paragraph (called a dropped capital), try this:
  1. Click anywhere in the paragraph
  2. Click the Insert tab on the Ribbon
  3. Click the Drop Cap icon in the Text group

[Source Yahoo Answers]

Sunday, March 27, 2011

HowTo: Conditional Formatting Emails in Outlook

If you gets lots of email, then this tip is for you. 

It would be nice to have emails that are color coded for specific categories. For example, emails that are only to you are one color and emails from some group distribution list are another color. Do accomplish this task, one can set up conditional formatting.

First, click on: View -> View Settings -> Conditional Formatting
Second, Add a new rule, which should be easy to figure out.

For all the details and screen shots, refer to this link.

[Source here]

Sunday, March 13, 2011

Macro: Remove Spacing Between Table Cells

I received a document that had hundreds of tables, all with a nice 3D border. Then somebody said that the border looked ugly so I started writing a macro to change all the borders to something more plain. Changing the borders was simple, but the cells had space between them which resulted in a double border. Getting rid of this space was not so simple.

Finally, I found this little macro at the Egghead Cafe:

With Dialogs(wdDialogTableTableOptions)
   .AllowSpacing = 0
   .Execute
End With
 
A second method (that I did not try) is to use this:
Selection.Tables(1).Spacing = -1
 
The full macro follows: