Why is my mail merge says next record?

The primary purpose of the “Next Record” field is to direct Word to merge subsequent data — in other words, the next name and address on the spreadsheet — into the following label instead of starting a new sheet of labels with each listing.

How do I preview the next record in merged letters?

You can preview your merged documents and make changes before you actually complete the merge. Click Preview Results. Page through each merged document by using the Next Record and Previous Record buttons in the Preview Results group. Preview a specific document by clicking Find Recipient.

How do I get rid of next record in labels?

In order to delete the Next Record If Field you will have to make it visible first.

  1. Press Alt + F9:
  2. Look for the NEXTIF Field:
  3. Delete it: See also: Word, Mail Merge. Word, Next Record If Rule (Mail Merge) Microsoft Office Support, Field Codes: Next field.

How do I fix mail merge formatting?

Press [Alt] + F9 again. Position the cursor anywhere in this field and press the [F9] function key to update it. Or, right-click the field and choose Update Field. Preview the results to confirm the number displays with the formatting you want to see in the document.

What are the disadvantages of mail merge?

Disadvantages of Mailmerge

  • Moving the data file, and renaming fields, can cause the mailmerge to fail, as the word processor program won’t be able to find them.
  • The database that provides the information, must be kept up to date.
  • It’s unlikely that every letter produced, will be checked for errors.

How do I preview mail merge before sending?

Compose your Mail Merge email and then tap on the Review button to review your email and make other changes before sending. You can scroll down the list of recipients and select them to preview the email with their unique merge fields and further personalize the message for each recipient.

How do I preview a letter in a mail merge?

Preview and print the letters

  1. Go to Mailings > Preview Results to preview your letters.
  2. Choose Next or Previous.
  3. Select Preview Results again switch from the merged results back to the mail merge fields in your letter.
  4. Select Finish & Merge > Print Documents.

How do I format a mail merge field in Word?

Format merge fields using Mail Merge switches

  1. In the template document, while the merge field is selected, do the following to display the field code: Press Shift + F9 on Windows.
  2. Remove ” \* MERGEFORMAT ” from the field code.
  3. Enter the switch in the field code. For example:
  4. Update the field: Press F9 on Windows.