If more are needed, then use an alternative Data Source. No more than 63 fields can be used (Word 97 and OK and Word will ask for a file name for your Data Source file. When all fields have been specified, select Use the Move Up/Move Down Commands to alter the order. The order of the fields will become the data entry order. You can use the fields provided and add/remove fields, or remove them all and create your own field names. Word displays a dialog box containing a default list of field names. In Step 2 of the Mail Merge Helper, select Create Data This is important if you want to be able to view or print data in alphabetical order by last name for a mailing list or directory but in ZIP code order when creating mailing labels or envelopes to qualify for bulk mailing rates. If you wish to use barcodes, the delivery address and postal code must be placed in separate fields Should you wish to sort by a specific piece of your information, it must be placed in a separate field. You can refer to the First name of an individual in a salutation and then use the First and Last in the inside address.įield gives you much more flexibility, because it lets you use “Joe ” Combining information in separate fields in a merge document is easy separating information in a field is difficult.įor an example of how difficult, see: I have a "Name" column which I want to split into "FirstName", "LastName", how can I do it? For example, create a separate field for First and Last names, break the City, State, and ZIP of an address into separate fields as well. Used Data Sources, along with how to set up a Data Source in Word.īreak your fields down into the smallest meaningful value. ![]() This article covers specifications and frequently asked questions on the most commonly Microsoft Word supports many file formats which can be used as a Data Source forĪ mail merge.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |