I have a good working knowledge of mail merge. I am trying to mail merge from Excel 2007 to Word 2007 onto mailing lables. When I complete the merge only the top row (3 labels), and bottom row right two labels are populated. I have tried running mail merge from an xls document to xlsx document to Word 2007 and Word 2003. I get the same result each time.
My steps are: use the Wizard- select labels- browse for recipents- confirm data source- "MS Excel Worsheets via DDE (*.xls)- entire spreadsheet- arrange labels- update all lables- preview labels- complete merge.
Does anyone know a good work around for this problem? Any suggestions would be appreciated.