This tutorial shows you how to create a custom view that shows just the name and mailing address in the view so that you can copy it for use in other programs.
Use VBA to create a new letter to contact
Contacts in the Business Card view can be copied, but to use them for address blocks, you'd need to remove the phone and email fields.
- If the Advanced toolbar is not visible in your Outlook, right click anywhere on the toolbar area to show it. (This makes it easier to access views.)
- Next, select Define views from the Current view selector.
- Copy the Address card view and rename it. (I used "Mailing Address Card")
- Once you click OK on the new view dialog, the Customize View dialog opens.
- Click on Fields.
- Remove all fields in the view except File As and Mailing Address.
- Apply the view and return to Outlook.
- Select the contact. If you want to copy multiple addresses, use the Shift or Control keys and select the first and last contact.
- Press Ctrl+C to copy. The right click menu will not offer Copy.
- Paste into the application where you need the list.
Tip: If you paste into Word, you'll need to use Paste Special as Text, otherwise, you'll paste the actual Contacts as OLE objects. Or first paste into Notepad, then copy from Notepad to paste into Word. (If you do this often, get PureText.)
More Information
If you edit the Address card view too much, field names may be included in the copy/paste:
Billy Joe Jackson
Mailing Address: 3750 Ash St
There, OH 44078
If this happens to you, delete the view and make a new one.
If you use the Full Name field instead of File As, the field name will show. While its easy enough to remove, even on many contacts (using Search and Replace), see Change Contact's File As format to change the file as format to First name Last name on all contacts.
