susan harkins

Blog Post

10 tips for helping users keep Outlook data secure

September 21, 2007 9:59am PDT

Your users probably understand the importance of safeguarding the data on their computers. But they don't always realize that some of that data is contained in Outlook. Here are a few suggestions...

7 Latest comment by mw00110011

Downloads

10 tips for helping users secure their Outlook data

September 21, 2007 12:00am PDT

Your users probably understand the importance of safeguarding the data on their computers. But they don't always realize that some of that data is contained in Outlook. Here are a few suggestions...

Provided by: Susan Harkins

Blog Post

Tip: Office 2003 Service Pack 3 available

September 19, 2007 6:55am PDT

This morning, I downloaded and installed Office 2003's latest service pack, published yesterday (September 18, 2007). The primary improvements seem to be in security. Specifically, the service...

17 Latest comment by ssharkins@...

Blog Post

Tip: Don't forget to cancel multiple sheet selections

September 17, 2007 6:27am PDT

It's common to make the same change to more than one sheet in an Excel workbook. For instance, you might want to change column widths or apply a format to a range of cells for several sheets. By...

Q&A

A simple solution for tracking changes to Access data...Error

September 12, 2007 9:00am PDT

A simple solution for tracking changes to Access data...Error I have searched this forum for some contact info on Susan Harkins who originally posted this download titled "A simple solution for...

3 Started by CEHinman@...  |  Latest comment by coretek2003@...

Blog Post

How do I... Start an Access label report with any label on the sheet?

September 10, 2007 10:41am PDT

Printing labels is a snap using Microsoft Office Access' Label Wizard. Depending on the criteria, the report prints the most up-to-date data in the order you need. The only problem is wasted...

9 Latest comment by dugoneill@...

Downloads

How do I... Start an Access label report with any label on the sheet?

September 10, 2007 12:00am PDT

Printing labels is a snap using Microsoft Office Access' Label Wizard. Depending on the criteria, the report prints the most up-to-date data in the order you need. The only problem is wasted...

Provided by: Susan Harkins

Blog Post

How to get the right average in Excel

September 9, 2007 8:33am PDT

Excel’s Average() function considers all the entries in the input range and 0s matter. For instance, if the input range is three cells, and one of those cells contains a 0, Excel totals the...

Blog Post

Tip: Finding items in Outlook's reading pane

September 9, 2007 6:51am PDT

Yesterday, I wanted to sort the 4,000 messages in my Deleted folder by the To field. Now, that field's not in the reading pane by default, so I added it, but it still wasn't there. Using the...

1

Blog Post

How to print Excel comments

September 5, 2007 11:35am PDT

Comments are scattered all over my Excel spreadsheets and I find them helpful. Most of the time, they're just for me -- they're reminders of partial payments, specific check numbers, and so on....

Blog Post

How to toggle Excel row and column headers

August 31, 2007 12:00am PDT

Excel displays heading cells for each column and row in every sheet. Those are the gray cells at the top of each column and to the left of each row. They help you navigate the sheet. However, you...

Blog Post

How to integrate existing tables with a PowerPoint presentation

August 24, 2007 12:00am PDT

You can create a table in PowerPoint, but if the table already exists in Word, why bother? It's more efficient to use an existing table. To insert an existing table into a PowerPoint presentation,...

Blog Post

How do I... Dynamically fill Microsoft Word fields using Access data?

August 23, 2007 10:31am PDT

This blog post is also available in PDF form as a TechRepublic download. The download includes a sample Access database and Word form. Each Microsoft Office application specializes in a specific...

26 Latest comment by Jurgen75

Downloads

How do I... Dynamically fill Microsoft Word fields using Access data?

August 23, 2007 12:00am PDT

Each Microsoft Office application specializes in a specific job. Word lets you create and edit documents and Excel analyzes your data. Storing data is Access' claim to fame. Fortunately, Office...

Provided by: Susan Harkins

Blog Post

How to slim down Outlook’s Message List

August 22, 2007 9:35am PDT

Outlook is very busy…sometimes too busy. Some of the default settings are overkill. If you’re like me, you want more message and less extraneous information about the message. By default,...

4 Latest comment by cbermudez@...

Blog Post

How do I... Export e-mail messages to Access using VBA?

August 20, 2007 1:56pm PDT

Exporting Outlook folders and their contents is a common and simple enough task most of the time. The Import And Export wizard handles the process nicely. But as easy as it is to use, the wizard...

16 Latest comment by wizard57m-cnet

Downloads

How do I... Export Outlook e-mail messages to Access using VBA?

August 20, 2007 12:00am PDT

Exporting Outlook folders and their contents is a simple enough task most of the time. The Import And Export wizard handles the process nicely. But as easy as it is to use, the wizard is a...

Provided by: Susan Harkins

Blog Post

How to select blocks of columnar text in Word

August 17, 2007 3:40pm PDT

Moving text from one column to another can be frustrating unless you know a trick or two. With tables, the move is easy. For instance, switching the second and third columns in the table below is...

4 Latest comment by ssharkins@...

Blog Post

How to use Access' conditional formatting feature with muliple controls

August 15, 2007 10:48am PDT

Recently, I learned that Access' conditional formatting feature handles multiple controls. For instance, you can use conditional formatting to highlight an entire row in a continuous form. To do...

Blog Post

How to change the display of Outlook contacts

August 12, 2007 1:30pm PDT

To address a new e-mail message, you may click the To button to display all your contacts. By default, Outlook displays the names in alphabetical order, by first name. If you have many contacts,...

7 Latest comment by kcjohns