Archive

Archive for the ‘Office Tips & Tricks’ Category

Office Tips: Remove Formatting and Paste

October 13, 2009 Leave a comment

Cut, Copy and Paste

When copy and pasting something into a Microsoft Office Application such as Word or Outlook, it will sometimes screw up the current format that you are having. This is normally happens when you copy and paste from other sources.

What you could do to remove the formatting is – Select the text that you have just pasted and use the shortcut key “Ctrl + Space”

Categories: Office Tips & Tricks Tags:

Limitation of Sending HTML Emails via Outlook

September 24, 2009 Leave a comment

In my previous post, I detailed out how to send HTML emails via Outlook. But I think its fair for me to also list out the limitations of Outlook 2007 so that you know what to expect

In Outlook 2007, Microsoft has removed the Internet Explorer based rendering engine and replacing it with Microsoft Word.

With that, Outlook 2007 has limited support for HTML and CSS to display HTML email messages. Unless your HTML emails are extremely simple, users of Outlook 2007 will have difficulty reading your message.

Here are some notable limitation:

  • no support for background images (HTML or CSS)  
  • no support for forms  
  • no support for Flash, or other plug ins  
  • no support for CSS floats  
  • no support for replacing bullets with images in unordered lists  
  • no support for CSS positioning  
  • no support for animated GIF’s  
    Normal Lenovo Page Lenovo Page In Outlook

    Normal Lenovo Page

    Lenovo Page in Outlook

    There is no immediate workaround or solution but to compose your HTML email around those limitation. For more information on Outlook’s rendering capabilities check out:

Sending WebPages (HTML) From Outlook

September 24, 2009 1 comment

Want to send an webpage as an email? There are many ways of doing this. For one, you could use Microsoft Outlook or Internet Explorer (IE).

Here’s how you can do it

Sending HTML pages in Internet Explorer

  1. Open the page that you want to send (Either on the web or any html page saved on your desktop)
  2. Go to Pages –> Send as Email
  3. Outlook would launch and you should see a HTML based email

Sending HTML pages in Outlook

  1. In your Outlook, select View->Toolbar-> Select Web
  2. You should see a new taskbar on your outlook with an web address input
  3. Open the page that you want to send (Either on the web or any html page saved on your desktop)
  4. Your outlook should show the webpage that you entered
  5. Go to Action –> Send Web page by Email

The result should be similar to the following.

Outlook Email HTML

Technorati Tags: ,,

tweetmeme_style = ‘compact’;
tweetmeme_source = ‘chrisleong’;

Excel Tips – View Worksheet Side by Side

April 10, 2009 Leave a comment

It’s been very long since i posted another office tips and tricks page. I sometimes needs to do that and it really is frustrating when you need to switch between Excel files. I guess this tip will be useful for those who needs to compare worksheet side by side.

So here how you can view your worksheets side by side.

On the View tab, in the Window group, click New Window.

Inst

clip_image004

On the View tab, in the Window group, click View Side by Side .

clip_image006

In the Compare Side by Side dialog box, click the worksheets that you want to compare. To scroll both worksheets at the same time, click Synchronous Scrolling  in the Window group on the View tab.

 

Thanks to Lee Chun Onn that provide me. Have a tips and tricks that you want to share. Email me :)

Free Outlook add-in to organize your email and make your inbox better

March 20, 2009 Leave a comment

Recently I am playing around with a free outlook add in to help me organize my inbox better. It’s call ClearContext Personal

Here are some things that it can help you with

  • suggesting the right folders to instantly file messages and entire conversations with a single click
  • highlights the most important messages in your Inbox from your most important contacts.
  • Easily follow the conversation with a threaded conversation view as part of each email message
  • Explore and preview attachments within Outlook just like folders on your desktop

So far i haven’t got use to the add in. I believe it takes some effort to adapt to it. But i guess once you got used to it, your productivity and efficiency in Outlook will increase.

But overall the best feature for me is the email thread function it provides. One of the things i like about Gmail is that it groups all similar emails. I find it easier for me to search for all my emails. It offers something similar, so far i like this feature the most.

In every mail, it will show you the email threads as highlighted in the picture below

 

Check out ClearContext’s short video demo

Import Gmail Contacts to Outlook 2007

March 6, 2009 Leave a comment

My friend post a question to me about importing Gmail contacts to Outlook. It is actually quite simple to do it, here are some steps to do it.

1) In Gmail, click on contacts. Then select that contacts that you want to import.

Gmail Export

2) Click Export

Gmail Export Contacts

3) In the next screen, select Outlook CSV contacts

image

4) Next go to Outlook 2007. Click on File –> Import and Export

5) Select “Import from another file”

6) Select “Comma Separated Value (DOS)”

7) Follow the instructions and you should see your Gmail contacts in Outlook

Outlook Tips – Add a Second Time Zone

January 23, 2009 2 comments

In my line of work, I do need to work with people from different time zones. Adding a different time zone can really helps to manage the time differences.

To add a new time zone. Go to Tools menu > click Options > Under Calendar . Calendar options

Outlook Timezones

Outlook Options

Under Advance options > Click Time Zone > select the Show an additional time zone check box. In the Label box, type a description such as “Houston”. In the time zone list, click the Time Zone and click “Ok”

Outlook Timezones

An additional time zone will appear next to your default time zone

2nd Timezone

Outlook Tips & Tricks – Managing your folders

January 6, 2009 1 comment

If you are like me, my Outlook mail have too many folders storing different types of emails. Searching for your folders can be messy.

Here are some tips on how to add your frequently use folder in your favourite list.

 

Favorite folders are shortcuts to your most commonly used folder. Think of it the same as your desktop shortcut. To create a favorite folder, simply drag any folder up to the Favorite Folders area and drop it.

Remember though, if you drag “too many” favorite folders then you will end up with the same problem. So it should some selected folders that you always use

 

Favorite Folders in Outlook

Favorite Folders in Outlook

 

 

The next time you need to access the folder, just click on the favorite folder.

To remove a favorite folder, just right click and select “Remove from favorite folders”. Do not, do not delete as it will delete the original folder as well

Remove folder from favorites

Record a webcast on your desktop

December 30, 2008 Leave a comment

Try out Office Community Clip. This is a useful tool that allows you to record your voice and all the activities in the screen in your desktop.

It is very useful tool for you to:

  • record your presentation and share it with others
  • Share your tips and tricks via video rather than text

Download the Office Community Clip and try it out..

Office 2007 Add-Ins – Save as PDF

December 4, 2008 Leave a comment

A friend of mine asked me what software to install to print office documents to PDF. Microsoft provides an Add-In to allow Office documents to be save as PDF format.

Hope this is useful for people who don’t know about it.

Microsoft Save as PDF