vasupfolder.blogg.se

• #Mail merge excel mac multiple fields full

Choose the correct field name from the list. To match the required field with our field names, click the drop-down arrow to the right. Notice that the First Name, Last Name, Address 1, and State fields are not matched. On the left of the dialog box is a list of fields required for all special fields. We can correct this by matching our field names with the fields used in the Address Block.įrom the Insert Address Block dialog box or the Write & Insert Fields group on the Ribbon, click Match Fields. When we attempt to use the Address Block feature, our results look like this: Several fields, Name-Last, Name-First, Addr, and ST, do not use the correct field names. This is an example of a data source in Excel that does NOT use the correct field names:

If this happens, you can tell Word exactly which fields should be used and where they should be placed. In these cases, the Address Block and Greeting Line features may not work as expected. However, you may have a data source which uses different field names. In a perfect world, everyone would be aware of, and follow, these naming conventions.

However, “Zip” is recognized for “Zip Code.”

#Mail merge excel mac multiple fields full

Use the full words “Address,” “City,” and “State.” Abbreviations of these words are not recognized by Word.The same varieties apply to the Last Name field. For the Name fields, you may use either “First Name,” “FName,” or even simply “First” to cause Word to recognize that the data in the field is associated with a first name.When using the Address Block or Greeting Line features of Mail Merge, the fields have to be specific.