Outlook 2007 - How to Export 1 Folder

To export just one folder in Outlook 2007.

• Click the File menu.
  
  
  
• Click Import/Export.
  
  
  
• Choose Export to a file.
  
  
  
• Click Next.
  
  
  
• Choose Personal Folder File and click Next.
  
  
  
• Select the folder you wish to export from the list, click the include subfolders box if you want to include subfolders.
  
  
  
• Create the name you'd like to use for your exported file. Decide if you want duplicated items created.
  
  
  
• Click Finish - and you're done.
  

For additional information on Outlook 2007, please see our webinars: Clearing Inbox Clutter and Mastering Outlook Tasks.

MS Access 2003 - Adding Tables from Another Database into a Query

The traditional way of adding a table from an external database into a query is by linking the table to your database.

There is another way, however.

In the query design grid, right click anywhere in the grey area.

Click Properties.

When the properties window pops up, type the full path of the external database in the Source Database box.

For additional information about designing Access Queries, see our course: Access Queries from A to Z.

How to Control Numbering in a Word 2003 Document

I recently taught an Intermediate Word 2003 class, and this was a question posed by one of the students:

I occassionally create documents with cover pages. How do I set up Word so that the first page in a document is the unnumbered cover page? What I'd like to see happen is for the second page in the document to be numbered page 1.

In order to do this, you would have to work with Word 2003's section break features. Here are the step-by-step instructions.

1 - Insert a New Page Section Break on the 2nd Page.

Switch to the 2nd page of your document.
Go to the Insert menu, and click Break.
Under Section Break Types, Choose Next Page.
(At this point, you can click View, then Normal to see the section page break - this is optional).

2 - View the Header and Footer Menu.

Click the View menu, then Header and Footer.
If you'd like to put the page number in the footer, click the button to Switch to Footer.

3 - Delete the link between the 1st and subsequent page(s) headers and footers.

On the Header and Footer toolbar, you will notice the Link to Previous section button is highlighted.
Click the Link to Previous button. This removes the link between the 1st page header/footer and the rest of the document's headers/footers.

4 - Insert your page numbers.

On the Header and Footer toolbar, click the button to insert the number of pages. Since you've deleted the link to the previous section, Word will start numbering on the second page of your document.