June 11, 2008

Store sent mail efficiently in Outlook

Date: June 10th, 2008

Author: Susan Harkins

When you reply to an e-mail, Outlook stores a copy of that message in the Sent folder. If you’re like me, your Sent folder has thousands of messages. If you need to find a specific message later, you must sort through all those messages, and that takes time.

Instead, you might your replies with the original message. For instance, suppose you automatically route all your messages from your boss into a folder named, appropriately enough, MyBoss. If you want Outlook to store your replies in MyBoss with the original messages, do the following:

  1. From the Tools menu, choose Options.
  2. On the Preferences tab (which should be selected by default), click E-mail Options in the E-mail section (Figure A).

Figure A

outlook options

  1. Click Advanced E-mail Options at the bottom of the Message Handling section (Figure B).

Figure B

  1. In the Save Messages section, select the In Folders Other Than The Inbox, Save Replies With Original Message check box (Figure C) and then click OK three times to return to Outlook.

Figure C

Outlook will apply this setting to all of your personal folders. Just remember that Outlook saves replies with the original message and not in the Sent folder only when the original message is in a folder other than the Inbox. Outlook continues to save all replies sent from messages in the Inbox in the Sent folder

Permalink • Print • Comment

Force a page break before a specific paragraph

Date: May 30th, 2008

Author: Susan Harkins

Everyone knows that Word automatically inserts new pages as you insert text and graphics. You don’t need to do a thing but add the content. However, you can manipulate where a page breaks yourself, if you want to. Simply choose Break from the Insert menu and click OK. Page Break is the default setting.

may2008blog9fig1r.jpg

For the most part, you should avoid inserting page breaks and let Word take care of them for you. Manual page breaks quickly become a nuisance. As you update your document by inserting or deleting content you usually have to fix the manual page breaks.

However, there are times when you might want to force a page break before a specific paragraph. By associating the break with the paragraph, you can insert and delete all you like. To force a page break before a specific paragraph do the following:

  1. Click inside the paragraph in question.
  2. Choose Paragraph from the Format menu.
  3. Click the Line and Page Breaks tab.
  4. Select the Page Break Before option, and click OK.

In Word 2007, open the Paragraph dialog box by clicking the dropdown generic propecia arrow at the bottom-right corner of the Paragraph group on the Home ribbon.

may2008blog9fig2r.jpg

Now you can add and delete content before the paragraph or even move the paragraph and Word will still force a page break before that paragraph.

Permalink • Print • Comment

Gather feedback by routing your Word documents

Date: June 3rd, 2008

Author: Mary Ann Richardson

You’ve just completed the documentation for your upcoming training course. Before presenting it, however, you would like to send it out to your colleagues for review. You can use Word 2002/2003’s Routing Slip feature to send the document as an e-mail attachment to each reviewer in the order designated by you. Word will then return the document to you with everyone’s proposed changes. Follow these steps:

  1. Go to File | Send To | Routing Recipient.
  2. Click Allow.
  3. Select the default text in the Subject box and enter Routing: Training document approval. (You can also enter your own Message text; if not, Word will add text for you.)
  4. Click the Address button.

  1. Click Allow.
  2. Click the name of the first reviewer in your list of addresses.
  3. Click the To button.
  4. Click the name of next reviewer in your list of addresses.
  5. Click the To button.
  6. Repeat steps 7 and 8 for each person on your list.
  7. Click the Add Slip button.

Word saves the routing slip with your document. After adding the routing generic propecia without prescription slip, you can work with the document as you would any other document. When you are ready to send it to everyone on the routing slip, go to File | Send To | Next Routing Recipient. In this example, the recipient will receive the message below, with the default message text.

Note that you will need a MAPI-compliant e-mail program, such as Outlook or Outlook Express, or a VIM-compatible program, such as Lotus cc:Mail, to add a routing slip to your Word 2002/2003 documents.

Permalink • Print • Comment

Save time reformatting by using Excel’s Fill function across worksheets

Date: May 27th, 2008

Author: Mary Ann Richardson

You have three worksheets in your workbook. They are all formatted the same; only the data is different. Each worksheet tracks the sales for all 12 months of the year for one of your three divisions. You’ve just made some changes to the font color and the background of the cell range B1:M1 in Sheet1, as shown below. You would like to copy that formatting to the other sheets. Follow these steps:

  1. Select the range B1:M1 in Sheet 1.
  2. Click Sheet1. Press and hold Shift and then click Sheet3. (All three sheets should be selected.)
  3. Click the arrow of the Fill button in the Editing group of the Home tab. (in Word 2002/2003, go to Edit | Fill.)
  4. Click Across Worksheets.

Click Formats and then click OK.

Right-click any generic propecia review worksheet tab, and select Ungroup Sheets.

Permalink • Print • Comment

Let Access keep track of the date and time of the last record update

Date: May 27th, 2008

Author: Mary Ann Richardson

Do you need to query your data by the last date modified? For example, say you would like to include donors whose records show no activity during the last six months in a special fund-raising appeal. How do you know which donors are to be included? Follow these steps:

  1. Add a field to your Donors table called Date Modified and assign it a Date/Time data type. Then, open the form used to update the table in Design view.
  2. Open the form’s property sheet.
  3. Click in the Before Update property box in the Event tab.

  1. Click the Build button and select Code.
  2. At the prompt, enter the following code:
Me![Date Modified].Value=NOW()

generic propecia no prescription

  1. Press Alt + Q.

Now each time a user changes a record, Access will enter the date and time from the system before the changes are updated. When the record is accessed again, the Date Modified field will contain the date and time of the last modification. You can query that field to determine which records have not been updated within the last six months.

Permalink • Print • Comment
Next Page »
Made with WordPress and an easy to customize WordPress theme • Sky Gold skin by Denis de Bernardy