txt file, then use the Text Import Wizard. If you create a mailing list by importing information from a. This will ensure that all leading zeros in your postal codes will remain intact.
This would allow you to easily use the GROUP BY capabilities that you seek. To correctly mail merge zip codes and any other numbers, please follow the recommendations provided in How to format mail merge numbers and dates. There you can do many types of processing-just as you can with an SQL database-in order to create views of information (queries) that can be used as the source data for a Word mail merge. The other option is to forego Excel and place your data in a real database program, such as Access. Thanks to a handy AppleScript app you can create mail merge documents with the latest versions of Pages and Numbers.Thanks to a handy AppleScript app you can create mail merge documents with the. The wizard will walk you through selecting the type of merge, selecting your recipient list (the data. In the Start Mail Merge group, click the Start Mail Merge button.If this is the first time you have used it, select Step by Step Mail Merge from the menu (it should be the last menu item). (Full information on some of these methods can be found on the ExcelTips site. Hi Joy: To start a mail merge, click the Mailings Tab. There are numerous ways that you can work with your data, including the removal of duplicate records or using macros to condense duplicate records into a single record. Here, you can select your label brand and product number. In the drop-down menu that appears, select Labels. This means that it may be best to examine the source and do any sorting, condensing, and selecting in the workbook before you do the merge. Next, head over to the Mailings tab and select Start Mail Merge. The merge feature generally takes information as it is fed from the source document. If you are doing any other type of merge (such as merging to letters or to labels), then you are pretty much out of luck. Quickly take a spreadsheet with contacts and create bulk envelopes with ease.
If you are doing that type of merge, you can find full information on how to group records at this Microsoft Office Support article: Learn how to Mail Merge to create envelopes using Microsoft Word and Excel. This is not something that can be easily done with Word's mail merge capabilities, with one exception: You can do it if you are doing a directory-type merge. She wants to "group" records so she can put all the records for a given individual into a single merge document.
She notes that if she was using SQL she could use "GROUP BY" to make sure that all the records of a given individual were grouped together. Erin wants to do a mail merge using source data that is in an Excel worksheet where it is possible for a given individual to have multiple rows of data.