AccessMyLibrary provides FREE access to over 30 million articles from top publications available through your library.

The urge to merge.(using Microsoft Word)

Personal Computer World

| June 18, 2009 | Nott, Tim | COPYRIGHT 2009 Incisive Media, published with the permission of Incisive Media. This material is published under license from the publisher through the Gale Group, Farmington Hills, Michigan.  All inquiries regarding rights should be directed to the Gale Group. (Hide copyright information)Copyright

Byline: Tim Nott

The urge to merge

Get to grips with one of Word's most feared features

One of the phrases that can strike terror into the hearts of mere mortals is 'mail merge', along with the closely related 'database'. The idea is that you send out a standard letter, personalised with individual names, addresses and possibly other items.

The Word mail-merge wizard does make it fairly simple, but it still exudes an air of mystery. Word offers you a bewildering array of list formats to import from, including Access Databases, Outlook Address books, Excel spreadsheets or Word tables. You can also create a new list on the fly -- this will be in Access (.mdb) format. The disadvantage of this is that it is US-based in the address format. The other great fear with mail merging is that you can not only get something wrong, but you can get it wrong over and over again in every letter.

Keep it simple

This month we're going to demystify mail merge, just using Word. First, before you go near the Mail Merge command, create your addresses using a Word table. Across the top of the table list the fields you want available for each entry -- such as Title, First Name, Surname, Address 1, Address 2, Town, County and Postcode. You don't have to stick with these names, and you can have more or fewer fields and they can be in any order, though it makes life easier to arrange them in the order they will appear in the address. Next, enter the data as per our sample. The Tab key will take you from field to field and, when you reach the end of a row, a further Tab will start a new row. Take care not to include spaces at the start or end of a field as this may mess up the formatting of the letters, but don't worry if a field wraps more than one line in a cell -- this won't happen in the merged letters.

Related articles from newspapers, magazines, journals, and more
Arial Software Announces E-Mail Merge 3.1 for Windows 95;
Press release article from: PR Newswire March 11, 1997 700+ words
...Software, creators of the original E-Mail Merge software, today announced their latest...merging technologies for e-mail. E-Mail Merge 3.1 ($79) for Windows 95 generates...professionals of all kinds can use E-Mail Merge to efficiently keep in touch with customers...
Arial Software announces E-Mail Merge 3.1 for Windows 95.
Press release article from: Business Wire March 11, 1997 700+ words
...Software, creators of the original E-Mail Merge software, today announced their latest...merging technologies for e-mail. E-Mail Merge 3.1 ($79) for Windows 95 generates...professionals of all kinds can use E-Mail Merge to efficiently keep in touch with customers...
Arial Software Drops E-Mail Merge(TM) To $99; Mass-Customized E-Mail Using...
Press release article from: PR Newswire September 23, 1996 700+ words
...internet e-mail utility, "Arial's E-Mail Merge," dropping the price to $99. Arial's E-Mail Merge runs under Windows 95 and allows users...value to our customers." Arial's E-Mail Merge works by reading records from any database...
ARIAL SOFTWARE DROPS E-MAIL MERGE TO $99; MASS-CUSTOMIZED E-MAIL USING...
Press release article from: Business Wire September 23, 1996 700+ words
...internet e-mail utility, "Arial's E-Mail Merge(TM)," dropping the price to $99. Arial's E-Mail Merge runs under Windows 95 and allows users...value to our customers." Arial's E-Mail Merge works by reading records from any database...
Mail merge problems Q/I have been having problems making address labels using...
Magazine article from: Computer Act!ve February 19, 2009 700+ words
Byline: Tim Smith Mail merge problems Q|I have been having problems...to Office 2000 and cannot find the mail merge function in Excel. Loading the information...labels for my mailing? Can I do the mail merge from one program without switching...
Mailing lists made easy: how to print labels with word's Mail Merge...
Magazine article from: Computer Shopper Woram, John December 1, 2005 700+ words
...hours of hand-cramping addressing: Mail Merge. This little Microsoft Word feature...step numbers coinciding with those of Mail Merge, to demystify its head-scratching...Tools > Letters and Mailings > Mail Merge. A Task pane will pop up on the right...
Named range for mail merge When using a Microsoft Excel sheet as the basis for...
Magazine article from: Computer Act!ve February 5, 2009 700+ words
Byline: Tim Smith Named range for mail merge When using a Microsoft Excel sheet as the basis for a mail merge it is possible to use a section of a...menu, Letters and Mailing and then on Mail Merge. Follow the wizard that appears in the...
Arial Marketing drops price of E-Mail Merge PRO to $199 through November, makes...
Press release article from: Business Wire June 10, 1996 700+ words
...announced a price promotion for Arial's E-Mail Merge PRO, an e-mail utility that lets users...mail messages in a manner similar to "mail merge" in word processing software -- but...e-mail newsletter. Arial's E-Mail Merge PRO is designed to allow companies of...
For more facts and information, see all results
©2009 Gale, a part of Cengage Learning. All rights reserved.
About us | FAQs | Contact us | Privacy policy | Terms and conditions
Other Gale sites: Encyclopedia.com | HighBeam Research | Acquire Content | Books & Authors | Goliath | MovieRetriever | Smart QandA