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, 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

  Friday, December 08, 2006 – Permalink –

Links to Nowhere

Fix the problem


Outlook and its step-brother Outlook Express can sometimes exhibit problems with hyperlinks sent in email.


Try these suggestions:

  1. Open IE and go to Tools>Internet Options >Programs.
  2. Check to see if there is a checkmark in the box labeled "IE should check to make sure it is the default browser".
  3. Click OK.
  4. Close IE.
  5. Reopen IE. click "Yes", when you are asked if you want to make it your default browser.

Another thing to try is to:
  1. Close IE.
  2. Go to Start >Run.
  3. In the Run box, type:

    regsvr32 urlmon.dll

  4. Click OK.
  5. Open IE.
  6. Go to Tools>Internet Options>Programs.
  7. Click "Reset Web Settings."



Also:

Using Microsoft Outlook Links
Turn on disabled links in a message



See all Topics

Labels:


<Doug Klippert@ 6:03 AM

Comments: Post a Comment