Mail Merge (Microsoft Word) - Word Tips - Tips.Net [PDF]

Word has a Mail Merge manager that makes putting individualized data into your document easy. The following articles exp

2 downloads 39 Views 43KB Size

Recommend Stories


Microsoft Word 2013 Hints & Tips
Love only grows by sharing. You can only have more for yourself by giving it away to others. Brian

50 Indispensable Microsoft Word tips
Don't count the days, make the days count. Muhammad Ali

Microsoft Word
The butterfly counts not months but moments, and has time enough. Rabindranath Tagore

Microsoft Word
Stop acting so small. You are the universe in ecstatic motion. Rumi

Microsoft Word
Be like the sun for grace and mercy. Be like the night to cover others' faults. Be like running water

Microsoft Word
Goodbyes are only for those who love with their eyes. Because for those who love with heart and soul

Microsoft Word
When you do things from your soul, you feel a river moving in you, a joy. Rumi

Microsoft Word
No amount of guilt can solve the past, and no amount of anxiety can change the future. Anonymous

Microsoft Word
Your big opportunity may be right where you are now. Napoleon Hill

Microsoft Word
Don't ruin a good today by thinking about a bad yesterday. Let it go. Anonymous

Idea Transcript


Word has a Mail Merge manager that makes putting individualized data into your document easy. The following articles explain the steps to perform a mail merge in Word to create labels, forms, notices, etc. printed with pieces of data from an input file. Taking advantage of this powerful tool in Word can save hours when preparing to print documents.

The following articles are available for the 'Mail Merge' topic. Click the article''s title (shown in bold) to see the associated article. Automatically Determining a Due Date (https://word.tips.net/T001760_Automatically_Determining_a_Due_Date.html) When you are doing a mail merge in Word, you may need to calculate a date sometime in the future. Word doesn't include an option to do this, but there are a couple of workarounds you can try. Beginning a Mail Merge (https://word.tips.net/T000084_Beginning_a_Mail_Merge.html) Performing a mail merge can be intimidating to some people. It needn't be; Word provides step-by-step wizards that lead you through the process. How you use these wizards is dependent on the version of Word you are using, however. Can't Merge Alphanumeric Data Correctly (https://word.tips.net/T000312_Cant_Merge_Alphanumeric_Data_Correctly.html) When you merge data from Excel into a Word document, you may need to do some conditional processing based on the data you are merging. This can lead to some screwy results at times. Here's an example and how to fix it. Can't Place Merge Field in Header Of a Catalog Merge Document (https://word.tips.net/T001578_Cant_Place_Merge_Field_in_Header_Of_a_Catalog_Merge_Document.html) Word can perform several different types of mail merge operations, and the type you choose can affect how you are able to use merge fields in the merge document. This tip explains how catalog merges are different from other types of merges, and how that affects placing merge fields in a header or footer. Checkboxes in a Merged Document (https://word.tips.net/T000511_Checkboxes_in_a_Merged_Document.html) When creating a mail-merge document, you may want to include some special characters, such as check-marked boxes, in the document. This is relatively easy to do by putting together the proper type of merge field, as discussed in this tip. Checking Your Data File (https://word.tips.net/T001371_Checking_Your_Data_File.html) When you get ready to merge a document with a data source, you'll want to make sure that everything is "as expected" before proceeding. Here's how to check out the information in your data file. Conditional Processing During a Mail Merge (https://word.tips.net/T000287_Conditional_Processing_During_a_Mail_Merge.html) The Mail Merge capabilities can appear limited at first glance. One thing that is often overlooked (and which makes the capabilities more powerful) is the ability to add conditional processing to your merges. Here's how to conditionally control how Word handles merging. Conditionally Adding a Period in a Mail Merge (https://word.tips.net/T000307_Conditionally_Adding_a_Period_in_a_Mail_Merge.html) When merging data into a Word document, you may want to add information to the document based on an evaluation of what is being merged. This can present a special challenge, as outlined in this tip. Controlling Date Formats in a Mail Merge (https://word.tips.net/T003878_Controlling_Date_Formats_in_a_Mail_Merge.html) One of the data sources that Word allows you to use for your mail merges is an Excel worksheet. You may get unexpected results, however, if you believe that the formatting used in Excel should merge smoothly into your Word document. This tip looks at how you can control the formatting for dates. Creating a Mail Merge Data File (https://word.tips.net/T001369_Creating_a_Mail_Merge_Data_File.html) An easy way to perform a mail merge starts with creating a data file in a Word document. This tip shows how you can create the data in a document in a tabular format that can be easily understood by the mail merge feature. Creating Files with Mail Merge (https://word.tips.net/T001326_Creating_Files_with_Mail_Merge.html) When you use mail merge to create a document that incorporates all your data source records, you end up with a large document that is divided into sections. You can use a macro to easily split such a document into individual files, one for each data record. Data Source File in Word 2003 (https://word.tips.net/T000338_Data_Source_File_in_Word_2003.html) The security features introduced in Word 2003 resulted in a change in the dialog boxes you see when opening mail-merge source documents. It is easy to be confused by the dialog boxes, but this tip helps to remove some of the confusion. Getting Rid of Blank Labels in a Filtered Merge (https://word.tips.net/T001790_Getting_Rid_of_Blank_Labels_in_a_Filtered_Merge.html) If you are filtering a mail merge in Excel, and you get blank labels in the printout in Word, chances are good that something is going wrong. (Filtering should suppress those blank labels.) This tip provides some guidance on what you should look for in your merge document to get the desired results. Getting Rid of Mail Merge Section Breaks (https://word.tips.net/T001201_Getting_Rid_of_Mail_Merge_Section_Breaks.html) When you create a group of documents from a merge file, Word normally inserts section breaks between iterations of the document. If you need to get rid of those section breaks, there are a couple of approaches you can take. Getting Rid of Spaces in Merged Data (https://word.tips.net/T008954_Getting_Rid_of_Spaces_in_Merged_Data.html) When you merge information with a Word document, you may not be completely satisfied with the appearance of some of the merged information. For instance, a merge field may include spaces within the information that you would rather remove. Here's a couple of ways you can get rid of those spaces. Grouping Records in a Mail Merge (https://word.tips.net/T007451_Grouping_Records_in_a_Mail_Merge.html) Need to group records in some manner when they are used in a mail merge? It can be frustrating when your records are not ordered in the way you want, but this seems to be a limitation of Word. The solution is to look to how you are organizing the data in the source program. Mail Merge and Data Source Documents become Unattached (https://word.tips.net/T000366_Mail_Merge_and_Data_Source_Documents_become_Unattached.html) When you create a mail merge document, you attach it to a data source that is the basis for the information to be merged with the document. Word remembers the relationship between the two files when you later open the document. If you send the two files to someone, it is possible for the relationship to be lost. This tip explains why this can happen. Maintaining Fields in a Merged Document (https://word.tips.net/T001736_Maintaining_Fields_in_a_Merged_Document.html) When merging documents, you may want to include some fields in the merged documents. For some fields this is impossible, as to include them would make no sense. Maintaining Leading Zeroes (https://word.tips.net/T000324_Maintaining_Leading_Zeroes.html) When merging ZIP Codes from a data source such as Excel, you might find that Word ends up dropping out leading zeroes in the ZIP Codes. Here's how you can make sure that those digits are not dropped. Merging and Printing (https://word.tips.net/T001862_Merging_and_Printing.html) When you merge information into a document, Word provides two different ways you can create your output. Here's an overview of those output options and how you can choose them. Merging Formatted Data (https://word.tips.net/T000143_Merging_Formatted_Data.html) Using the mail merge feature of Word, you can make data from Access databases accessible for your documents. How information is stored in the Access database can affect the way that data looks once merged into Word. This tip discusses ways you can make phone numbers appear formatted properly in Word. Merging Graphics from Access (https://word.tips.net/T000673_Merging_Graphics_from_Access.html) An Access database can store all types of data, including graphic images. Merging most data from Access into Word is relatively easy, except when it comes to graphics. This tip explains why this is the case and ways you can work around the problem. Merging Only a Date from Access (https://word.tips.net/T000428_Merging_Only_a_Date_from_Access.html) When you are merging data from an Access database, you may get more information than you want, especially when it comes to times and dates. There are two potential solutions to this problem, both of which are detailed in this tip. Merging with Two Data Sources (https://word.tips.net/T003337_Merging_with_Two_Data_Sources.html) Setting up a Word mail merge to combine a data source with a merge document is easy. But what if you want to use two data sources? Well, depending on what you want to do, you may be out of luck. Opening Only a Merge Document (https://word.tips.net/T001533_Opening_Only_a_Merge_Document.html) After merging the information from a data source into a document, you may decide that you only want to open the merge document from that point on. This tip explains how Word treats the files involved in a mail merge. Picking a Starting Label (https://word.tips.net/T001555_Picking_a_Starting_Label.html) If you use the Labels feature in Word, you may want to specify which label to use as the starting point when printing. Here are a few options to try. Printing Multiple Label Copies when Merging (https://word.tips.net/T001627_Printing_Multiple_Label_Copies_when_Merging.html) Need to print more than one copy of mail-merge labels? There are a number of different approaches you can take to getting the number of labels you need. Printing Portions of Mail Merged Documents (https://word.tips.net/T001126_Printing_Portions_of_Mail_Merged_Documents.html) When you use a data source to create a bunch of documents in a mail merge, you might not want to print all the documents created by Word. Here are a number of ways you can print just what you want to print from the merge. Proper Comparisons for Dates in Merge Fields (https://word.tips.net/T000356_Proper_Comparisons_for_Dates_in_Merge_Fields.html) How Word merges a data source with a document is controlled by merge fields. In those fields you may want to compare dates to determine what Word displays. Here's a primer on how these comparisons occur. Selecting Different Trays in a Mail Merge (https://word.tips.net/T003519_Selecting_Different_Trays_in_a_Mail_Merge.html) When you create a mail-merged document, you might want some pages of the document printed on paper from one printer tray and other pages printed from paper in a different tray. This can be easily accomplished when you create your merge document to begin with. Speeding Up Mail Merges (https://word.tips.net/T001304_Speeding_Up_Mail_Merges.html) The Mail Merge tool in Word is a great way to create new, customized documents. If you are doing a lot of merging, you may notice that your merges slow down after a time. This tip discusses some of the possible reasons. Using Mail Merge to Complete Documents (https://word.tips.net/T001307_Using_Mail_Merge_to_Complete_Documents.html) Mail merge can be used to put together groups of documents that rely on common information. This tip shows how mail merge could be used to make your document generation easier. Using Merge Fields (https://word.tips.net/T001370_Using_Merge_Fields.html) When creating a mail merge document, you use merge fields to indicate where the information from each record of your data source should be inserted. This is easy to do, but the tools you use to place the merge fields depend upon the version of Word you are using. Using Unique Document Serial Numbers (https://word.tips.net/T001746_Using_Unique_Document_Serial_Numbers.html) If you need to include serial numbers in your printed matter (labels, letters, documents, etc.), the best way is through the use of Word's mail-merge capabilities. This tip outlines how you can use this capability to get just the serial numbers you need. Wrong Values Merged from Excel (https://word.tips.net/T000330_Wrong_Values_Merged_from_Excel.html) When you use an Excel workbook as a data source for your merged document, you may be surprised if what is merged doesn't match what you see in Excel. This could be due to how Excel formats and displays numbers and how those numbers are shared with other programs, like Word. Copyright © 2017 Sharon Parq Associates, Inc. (http://www.sharonparq.com)

Smile Life

When life gives you a hundred reasons to cry, show life that you have a thousand reasons to smile

Get in touch

© Copyright 2015 - 2024 PDFFOX.COM - All rights reserved.