View Single Post
 
Old 06-23-2015, 05:43 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your attachment contains mergefields and is set up to be used as a mailmerge main document for a letter-type merge with a data source where the fields for each page are all part of the same record (i.e. the same row in an Excel workbook, not on separate rows). The Excel workbook column headings for this would be:
First_Name_Defendant_1 Last_Name_Defendant_1 Address_Line City State ZIP_Code First_Name_Defendant_2 Last_Name_Defendant_2 Address_Line_2 City_2 State_2 ZIP_Code_2 First_Name_Defendant_3 Last_Name_Defendant_3 Address_Line_3 City_3 State_3 ZIP_Code_3
and so on. Using a letter-type merge with that arrangement, the mailmerge would automatically generate a new page for each record.

Your problem description, particularly the part about 'all these extra fields that don't exist in the excel document', suggests you're no longer using the Excel workbook the document was designed for and the new workbook doesn't have the same structure.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote