Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Saturday, April 25, 2009 – Permalink –

Change Categories

Fit people into the right peg hole



Go to View>Arrange by>Current View and select by Category.
(View>Customize Curent View)

You can create a new Category and then just select Contacts and drag them into the right slot.

This technique works with any Outlook item for many Outlook fields, including Private and Company but won't work on fields that aren't editable. You can use it to add Categories but not remove them.
  1. Make sure at least one item has the new field value.
  2. Create a new view or edit one of the existing group by views to group by the field you want to change
  3. Apply the view.
  4. Select one or more items from the other groups and drag them to the new group and drop.
Slipstick.com:
Group By




See all Topics

Labels: ,


<Doug Klippert@ 3:48 AM

Comments: Post a Comment


  Thursday, June 19, 2008 – Permalink –

Global Area Code Changer

Fix Contacts


Telephone area codes sometimes run out of numbers and need to be split. Slipstick.com's Outlook Contacts Tools page offers some suggestions including:


Slovak Technical Services:
Phone Changer

After a reorganization or buyout, have you ever needed to replace domain portion of e-mail addresses in a Contacts folder?

Here's a macro from Woody Leonard's WOPR forum.

Global Change of email addresses

(If you use it, you might want to comment out some of the MSGBOX entries. )




See all Topics

Labels: , ,


<Doug Klippert@ 4:53 AM

Comments: Post a Comment


  Saturday, June 14, 2008 – Permalink –

Address Layout

Custom layout


When you use the Outlook as a source for addresses, you can customize the display to suit your own needs.

When you use the Insert Address button in the Envelopes and Labels dialog box it does not use the same format as the Insert Address button.

Here's the location to put the Address book on the Quick Access Toolbar in 2007:



Here's the work around:
Insert Address Button Does Not Use AddressLayout AutoText Entry

MacroButton; scroll down to Insert Address from Outlook>



Here are two sources with directions about how to reformat the AutoText entry: "AddressLayout".

Slipstick.com
Inserting Addresses into Microsoft Word Documents


Microsoft Knowlegebase:
HOW TO: Modify the Layout of an Address Book Entry



See all Topics

Labels: , ,


<Doug Klippert@ 7:13 AM

Comments: Post a Comment


  Tuesday, June 10, 2008 – Permalink –

Auto Link

Outlook Contacts in Access


Automatically set up links to data outside of Access.
It still works in Access/Outlook '07.

Try this:

  1. Choose File >Open from the menu bar.
    (Office button>Open in 2007)
  2. Under Files Of Type choose Outlook().
  3. Locate your Outlook PST files.
  4. Choose Contacts, or if you have set up separate files for different groups choose an appropriate one.
  5. The wizard walks you through the process of creating an Access database with a linked Contact table.




The changes made in Access will be reflected in Outlook and vice versa.

If you want to create a new database that will link to other data that isn't in an Access format, you can do it quickly.

The classic way is to use the File>Get External Data >Link Tables method.

However you can simply choose File >Open from the menu bar.

Select the appropriate data format from the Files Of Type dropdown list
(such as Microsoft Excel (*.xls)).

Open the file and Access will automatically create an MDB file with the same name as the data source you selected and will set up links to the data.

From there you can develop forms, queries and reports.



See all Topics

Labels: , ,


<Doug Klippert@ 7:48 AM

Comments: Post a Comment


  Saturday, February 16, 2008 – Permalink –

Address Map

Display a map to an Outlook contact's address


If a contact item has an address in the United States, you can use your Internet connection and Outlook to create a map to the address. You must be connected to the Internet for this feature to work.

Open the contact item.

Next to the Address text box, click on the down arrow and select the address you want to map (Business, Home, or Other).

Then choose Actions/Display Map Of Address from the menu bar or click the Display Map Of Address button.

Your default browser opens and the map is created using Microsoft Expedia Maps.

Outlook Maps

In Outlook 2007, the Map button is on the Contact tab on the right side of the Communicate group. 2007 uses Maps.Live.com.

Outlook tips:
Outlook MVP Diane Poremsky
Customize Outlook's Map link
You can edit the registry to enable another web-based mapping service.

[Edited entry from 12/4/2004]



See all Topics

Labels: , ,


<Doug Klippert@ 8:29 AM

Comments: Post a Comment


  Friday, December 07, 2007 – Permalink –

Free Contact Templates

Free electronic business cards


Microsoft has 41 business card templates that can be used in Outlook.

Just download the file and edit the information.



Contact Cards



See all Topics

Labels:


<Doug Klippert@ 5:10 AM

Comments: Post a Comment


  Tuesday, November 13, 2007 – Permalink –

Last Name First

Phonebook style


Sort the Contacts list by the File as field.

To do this, use one of the following methods depending on the version of Outlook that you are using.

In Outlook 2007, follow these steps:


1. Start Outlook 2007.

a. On the Tools menu, click Account Settings.

b. Click the Address Books tab, and click Change.

c. Under Microsoft Office Outlook Address Books, click the address book that you want to change the contact display format for.



For example, Contacts: Mailbox - Personal Folders, and then click File As (Smith, John).


In Outlook 2003, follow these steps:

1 Start Outlook 2003.

a. On the Tools menu, click E-mail accounts.

b. Click View or change directories or address books, and then click Next.

c. Click Outlook Address Book, and then click Change.

d. Under Outlook Address Books, click the address book that you want to change the contact display format for. For example, Contacts: Personal Folders, and then click File As (Smith, John).

e Click Close, and then click Finish.

2. Quit and restart Outlook.

3. Verify that the newly created contacts are sorted in the LastName, FirstName format. To do this:

a. On the Tools menu, click Options.

b. Click the Preferences tab, and then click Contact Options.

c. In the Contacts Options box, click Last, First in the Default File As order list.

d. Click OK two times.

4. Edit the properties of any contacts that have the File as option configured individually. This setting overrides the setting that you made in step 1.

a. Double-click any contact that does not appear in the LastName, FirstName format in your Contacts list.

b. Click the General tab, click the down arrow next to File as, and then click Lastname, Firstname, where Lastname, Firstname is the name of the contact.

Lastname first



See all Topics

Labels:


<Doug Klippert@ 5:14 AM

Comments: Post a Comment