I’ve followed all the steps to set up the mail merge (see below), but when I go to print, it only prints a portion of the records. When I go to FIle> Print, I say ‘yes’ I want to print a form letter. I have tried the radio button for ‘all’. I have tried ‘selected records.’ I’ve tried manually selecting them one at a time, I’ve tried selecting them as a whole (by clicking the upper most left box in the spreadsheet). Whatever I try, the most I can get is half the records. It is basically skipping every other one. PLEASE HELP
STEPS to set up mail merge:
I have a spreadsheet. I register the spreadsheet as the data source. The test connection is successful. I set up the field assignments. I go to File> New> Labels. After adding my fields, I put my cursor in at the end of the last text position after the last field in the first record label and choose Insert>Fields> Other per the help instructions. I synchronize the labels. Then I go to print, select all my records and only get half of them printed as explained above.