Windows IT Pro is the leading independent community for IT professionals deploying Microsoft Windows server and client applications and technologies.
  
  
  Advanced Search 


July 09, 2002

Using Word Mail Merge to Print an Outlook Contacts List

RSS
Subscribe to Windows IT Pro | See More Outlook 2000 Articles Here | Reprints | Or get the Monthly Online Pass—only $5.95 a month!

Outlook presents a number of printing problems that users can find difficult to resolve. For example, printouts of custom forms don't look anything like what you see on the screen: Fields appear in a predetermined order that you can't change, and any custom fields are listed at the end in alphabetical order. The best custom form-printing solution I've found is to program an Outlook form to push its data into the fields in a Microsoft Word template.

Outlook printing dilemmas aren't limited to custom forms. When people who have amassed many lines of notes in individual Contact items try to print multiple contacts from the Address Cards view, they find that Outlook truncates those notes. The problem is that printing from any folder view is strictly a matter of what you see is what you get. Folder views never show the full text of the Notes or Message field, only a maximum of about 250 characters, so you can't use a folder view to print those notes in their entirety.

The solution built into Outlook is to use the Memo print style to print individual contacts. This technique doesn't produce a neat listing that looks like the Address Cards view, but the Print dialog box displays a "Start each item on a new page" option that you can leave unselected to conserve a little paper. Outlook's rules determine which fields are printed—typically, all those in which you've entered data.

When you need a compact printout of just a few key fields plus your notes from the Contacts folder, the solution-–just as with custom forms-–is to use Word. Unlike the custom forms solution, though, you don't need to write any programming code. Instead, you can use Outlook's integration with Word's Mail Merge feature. You need Outlook 2002 or Outlook 2000 to make this method work.

The trick is to start the merge from Outlook, not Word. Make sure the Contacts folder view is displaying the fields you want to print in the order you want them printed. Then, choose Tools, Mail Merge. Under "Fields to merge," choose "Contact fields in current view." Under "Document type," choose Catalog. Click OK to start Word and launch the merge process.

After Word starts, use the Insert Merge Fields button on the toolbar to add a placeholder for each Contact field to the merge document. (In Outlook 2002, that button is to the left of the Insert Word Field button.) You can format the merge document any way you like and insert additional text as needed. For example, you might highlight the FullName field with bold text or shading or preface other merge fields with labels such as "Email:" and "Notes:" to duplicate the look of the Address Cards view.

Be sure to include one or two blank lines after all the merge fields to provide separation between entries. If you want the printout to duplicate the multiple-column look of the Address Cards view, choose Format, Columns to select the number of columns. You might want to use File, Page Setup to switch the page from portrait to landscape orientation if you plan to display more than two columns.

After you finish editing the merge document, click the Merge to New Document button and choose to merge From 1 To 10 as a test. Examine the resulting document, then go back to your merge document, make any necessary changes, and test again. When you're satisfied, click the Merge to New Document button one more time, and choose All. Depending on the number of contacts and the complexity of your layout, Word might take a few seconds or a few minutes to perform the merge. After Word completes the merge, you can do additional formatting and cleanup before printing out your customized contacts list.

The one thing you lose with this method is any formatting in the notes section (printing in Outlook's Memo style preserves this formatting). That loss is a small price to pay, I think, for the much greater control that you gain over the layout.

End of Article



Reader Comments

You must be a registered user or online subscriber to comment on this article. Please log on before posting a comment. Are you a new visitor? Register now




Top Viewed ArticlesView all articles
Command Prompt Tricks

One reader shares his tip for setting up the command prompt to reflect a remote path. ...

WinInfo Short Takes: Week of November 9, 2009

An often irreverent look at some of the week's other news, including some more Windows 7 sales momentum, some Sophos stupidity, Microsoft's cloud computing self-loathing, more whining from the browser makers, Zoho's "Fake Office," and much, much more ...

Understanding File-Size Limits on NTFS and FAT

A general confusion about files sizes on FAT seems to stem from FAT32's file-size limit of 4GB and partition-size limit of 2TB. ...


Exchange Server and Outlook Whitepapers Take Control of Your Email: Understand the Business Reasons for Email Storage Management

Continuous Data Protection and Recovery for Microsoft Exchange

Related Events WinConnections and Microsoft® Exchange Connections

Check out our list of Free Email Newsletters!

Exchange Server and Outlook eBooks Spam Fighting and Email Security for the 21st Century

Understanding and Leveraging Code Signing Technologies

The Expert's Guide for Exchange 2003: Preparing for, Moving to, and Supporting Exchange Server 2003

Related Exchange Server and Outlook Resources Introducing Left-Brain.com, the online IT bookstore
Looking for books, CDs, toolkits, eBooks? Prime your mind at Left-Brain.com

Discover Windows IT Pro eLearning Series!
Clear & detailed technical information and helpful how-to's, all in our trademark no-nonsense format

Exchange & Outlook UPDATE eNewsletter
News, strategies, products, and developments in Exchange Server and Outlook messaging.

Windows IT Pro Home Register FAQ for Windows WinInfo News
Europe Edition About Us Contact Us/Customer Service Media Kit Affiliates / Licensing  
SQL Server Magazine Office & SharePoint Pro DevProConnections IT Job Hound
Left-Brain.com Technology Resource Directory asp.netPRO ITTV Windows SuperSite 
 
 Windows IT Pro is a Division of Penton Media Inc.
 © 2009 Penton Media, Inc. Terms of Use | Privacy Statement