Using Proper Addresses from Outlook

by Allen Wyatt
(last updated March 5, 2015)

Many people use Outlook to help manage their address lists and other contact information. Being a member of the Office family of products, Outlook provides a high degree of compatibility with Word. But that doesn't mean you won't have problems from time to time. For instance, subscriber David Lewis wrote recently about a problem he was having getting the home address from Outlook into Word when he tried to insert addresses from the address book.

The rules followed by Word when inserting addresses are pretty strict. Those rules are, interestingly enough, defined by an AutoText entry named AddressLayout. Long-time WordTips readers know that I have covered how to work with AutoText entries in other issues of WordTips. But the bottom line is that if you change the AddressLayout entry, you change what information is imported from Outlook and placed in your Word document when you insert an address from the address book. If you don't change the AddressLayout entry, it doesn't matter what else you do--you won't get what you want.

By default, the AddressLayout entry looks something like this:

{<PR_GIVEN_NAME>} {<PR_SURNAME>
}{<PR_COMPANY_NAME>
}{<PR_STREET_ADDRESS>
}{<PR_LOCALITY>}, {<PR_STATE_OR_PROVINCE>}{<PR_POSTAL_CODE>
}

With all these braces, the AddressLayout entry many look suspiciously like it contains field codes; it does not. Those braces are really braces--they are not field codes. Assuming you understand how to change AutoText entries (you really did read those earlier issues of WordTips, didn't you?), then the trick becomes learning what Outlook field names you can use in your AddressLayout. For that information it is best to refer to a Microsoft KnowledgeBase article or two. If you are using Word 97, refer to article Q141874. If you are using Word 2000, you should refer to article Q211424. You can, of course, access these KnowledgeBase articles online at the following addresses:

http://support.microsoft.com/kb/141874
http://support.microsoft.com/kb/211424

If you want more in-depth information about how this AddressLayout entry works, you can also check out the following KnowledgeBase article (Q134901):

http://support.microsoft.com/kb/134901

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (912) applies to Microsoft Word , , , , and .

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Transposing Letters

My fat fingers sometimes result in typing letters in the wrong order. Here's a quick tool that allows you to easily transpose ...

Discover More

Counting Cells According to Case

Text placed in cells can either be lowercase, uppercase, or a mixture of the two. If you want to count the cells based upon ...

Discover More

Reducing File Size

As you work with a workbook (particularly one that contains macros) you may notice that the workbook size can become quite ...

Discover More

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

MORE WORDTIPS (MENU)

Picking Which Outlook Address to Use in Word

If you Outlook addresses have more than one address each, you may want to select which one is used in Word.

Discover More

Getting Rid of Addresses

Word interfaces easily with other Office programs, such as Outlook. As an example, the Envelopes and Labels dialog box ...

Discover More

Accessing a List of Outlook Contacts

The information stored in Outlook can be utilized in Word, the same as with any other Microsoft Office application. Getting ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments for this tip:

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)