me think :): Office 2010

Showing posts with label Office 2010. Show all posts

Tuesday, September 30, 2014

word problem

A MS Office 2010 user encountered this problem with MS Word 2010: Whenever using spell check function, MS Word will simply hang and becomes unresponsive. To end it, you have to kill the process from the task manager. It happens to any word document.

Check for the following:

- Launch winword /safe from run or from cmd and check.
- Check for any addins or plugins and disable it and check.

This should resolve the problem.

- wong chee tat :)

Thursday, October 10, 2013

Print to the Microsoft XPS Document Writer

The XPS Document Writer allows you to create .xps files using any program that you can print from in Windows. Print to the XPS Document Writer when you want to create, send, and share or publish documents that you do not want other people to modify, or when you want to print a document or display it online exactly as it appears on your screen. It's also a good idea to create an XPS document for files that contain graphics or illustrations that might otherwise display differently in print than online or on computers with different monitors.

XPS documents are easy to share because you can view them on any computer where an XPS viewer is installed, even if the computer doesn't have the same programs that you used to create the original documents. For more information about XPS documents, see XPS documents: frequently asked questions or go to the Microsoft XML Paper Specification website.

To print to the XPS Document Writer

Open the document or file that you want to print to .xps format, and then click Print. In most programs, the print option is available from the File menu.
In the Print dialog box, select Microsoft XPS Document Writer.
To view the document using the XPS Viewer after you print it, click Preferences, click the XPS Documents tab, make sure that the Automatically open XPS documents using the XPS viewer check box is selected, and then click OK.
Click Print to print the document or file.
When prompted, enter a file name and browse to the location where you want to save the .xps file. Click Save. Windows will save .xps files in your Documents folder by default.

After printing to the .xps file format, you can view an XPS document by browsing to it and opening it. You can print a paper copy, share the XPS document, or send it to a commercial printer or to other people in any way that you prefer.

Tip

To help prevent security problems, you can attach a digital signature to an XPS document before you send or share it. The digital signature identifies the creator of the XPS document and helps warn anyone who views it if the document was modified after it was digitally signed. You can also determine who can view the document and for how long by applying permissions before sharing the document.

- wong chee tat :)

Friday, April 26, 2013

How to create a email archive for MS Outlook 2010?

How to create a email archive for MS Outlook 2010?

Actually, it is very simple:

1) From MS Outlook 2010, go to File --> Info --> Account Settings --> Account Settings

2) Under Account Settings, look for the 2nd tab and select Data Files.

3) To create a new email archive, select Add and enter the new name for the email archive (.pst)

4) Once created, you will see the archive created in MS Outlook 2010.

- wong chee tat :)

Wednesday, March 6, 2013

Freeze Top Row in MS Excel 2010 and OpenOffice

Doing some data analysis and I felt there is a need to create a top row and "freeze" it using excel 2010. I provided the screenshot above.

To do so:

Select the top row to be "freeze". Go to View --> Freeze Top Row and it works!

What about for openoffice users?

I'm using OpenOffice 3.4.1 and to do so, there is a slight difference:

Select the row below the one you want to freeze (in this case, the second row), then go to Window --> Freeze.

- wong chee tat :)

Thursday, February 28, 2013

Recall or replace an email message that you sent

The recall feature in Microsoft Outlook tries to stop delivery and, optionally, replace an email message that you have already sent to another Microsoft Exchange Server user within your organization. Message recall is available after you click Send and then realize that you forgot to attach a file, include information in the message, or want to revise what was originally sent. You can’t recall messages sent to email addresses outside your organization.

Note A Microsoft Exchange Server account is required.

In this article

Recall a message

To recall a message without sending a revised message, do the following:

In Mail, in the Navigation Pane, click Sent Items.
Open the message that you want to recall.
On the Message tab, in the Move group, click Actions, and then click Recall This Message.
Click Delete unread copies of this message.

Note If you don’t see the Message tab, make sure that you have opened a sent message as described in steps 1 and 2.

Recall This Message command on the ribbon

Note If you are sending the message to many people, you may want to clear the Tell me if recall succeeds or fails for each recipient check box.

Top of Page

Recall and replace a message

In addition to trying to recall a message, you can send a replacement message. For example, if you forgot to include an attachment, you can try to recall the message, and then send a replacement message that has the attachment. The original message is removed from the mailboxes of the recipients who have not yet opened it, and then is replaced with the updated message.
To recall a message and then send a revised message, do the following:

In Mail, in the Navigation Pane, click Sent Items.
Open the message that you want to recall and replace.
On the Message tab, in the Move group, click Actions, and then click Recall This Message.

Click Delete unread copies and replace with a new message.

Note If you are sending the message to many people, you may want to clear the Tell me if recall succeeds or fails for each recipient check box.

Click OK, and then update the new message. You can also remove or add file attachments.
Click Send.

Top of Page

Scenarios that affect recall success

The success or failure of a message recall depends on the recipients' settings in Outlook. In the following table, five scenarios are presented:

Four scenarios that explain what happens when message recall is tried in various situations
One scenario that describes what happens when the recall of a message that was sent to a Microsoft Exchange public folder is tried

Action	Result
You send a message to someone. You recall the original message and replace it with a new one. On the recipient's computer, under Tracking, the Automatically process requests and responses to meeting requests and polls check box is selected. Note To view this setting, click the File tab. Under Outlook, click Options, click Mail, and then scroll to the Tracking section.	Both the original message and the recall message are received in the recipient's Inbox. Assuming the original message has not been read, the original message is deleted and the recipient is informed that you, the sender, deleted the message from his or her mailbox. Note If the original message is marked as read (viewing in the Reading Pane is not reading in this scenario) when the recall message is processed, the recipient is informed that you, the sender, want to delete the message. However, the message remains in the recipient's Outlook folder.
You send a message to someone. You recall the original message and replace it with a new one. On the recipient's computer, under Tracking, the Automatically process requests and responses to meeting requests and polls check box is not selected. Note To view this setting, click the File tab. Under Outlook, click Options, click Mail, and then scroll to the Tracking section.	Both the original message and the recall message are received in the recipient's Inbox. On the recipient's computer, one of the following results occurs: If the recipient opens the recall message first, the original message is deleted, and the recipient is informed that you, the sender, have deleted the message from their mailbox. If the recipient opens the original message first, the recall fails, and both the original and recall messages are available. Note If the original message is marked as read (viewing in the Reading Pane is not reading in this scenario) when the recall message is processed, the recipient is informed that you, the sender, want to delete the message. However, the message remains in the recipient's Outlook folder.
You send a message to someone. You recall the original message and replace it with a new one. On the recipient's computer, either by rule or by action of the recipient, the original message is moved out of the Inbox to another folder and the recall message remains in the Inbox (or it is moved to another folder also).	If the recall message and the original message exist in separate folders, the recipient receives a message that indicates a recall attempt failed. This occurs regardless of the Outlook configurations and the read status of the message. The original message and the new message are both available to the recipient.
You send a message to someone. You recall the original message and replace it with a new one. On the recipient's computer, either by rule or by action of the recipient, both messages are moved to the same folder. This results in behavior similar to what occurs when Outlook is not configured to automatically process messages.	On the recipient's computer, one of the following results occurs: If the recipient opens the recall message first, the original message is deleted, and the recipient is informed that you, the sender, deleted the message from his or her mailbox. If the recipient opens the original message first, the recall fails, and both the old and new messages are available.
You send a message to a public folder. You recall the original message and replace it with a new one.	One of the following results occurs: If the recipient who reads the recall message has read access to all the items in the public folder but did not read the original message, the recall succeeds, and only the new message remains. You, the sender, receive a message that indicates the recall succeeded. If the recipient has already marked the original message as read, he or she is informed that the recall failed, and only the recall message is deleted. If a user who has any other public folder rights opens the recall message, the recall fails, and the user receives a message that states the recall failed. Both the old and new messages remain in the public folder. Notes If the recipient reads the original message and then marks it as unread, it is considered never read and recall is successful. In the public folder, it is the reader's rights, not the sender's, that determine the success or failure of the recall.