![]() When doing a mail merge, empty rows may mislead Word, so it will merge only part of the entries believing it has already reached the end of your address list. Make sure your Excel sheet does not contain any blank rows or columns.Format the Zip code column as text to retain leading zeros during a mail merge.For example, instead of a single Name column, you'd better create separate columns for salutation, first name and last name. Split the recipient information into very small pieces.Giving identical names to your Excel column will help Mail Merge to automatically match the fields and save you the trouble of mapping the columns manually. The screenshot below shows a list of the Address block fields used by Word. #Mail merge word for mac from excel full#For address fields, use the full words such as Address, City, State, Postal or Zip code, Country or Region.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |