If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Mail merge for labels
I'm trying to make mailing labels in Word 2007 from an Excel 2007 database,
but the merge ends at record 249 rather than the actual 700 records. I haven't had any problem doing this kind of merge before with longer recipient lists. I've checked the database which looks ok and tried starting over using mail merge. Any help would be appreciated. |
#2
|
|||
|
|||
Mail merge for labels
I do not know what is wrong, but...
As a workaround, you may be able to copy/paste the entire database into a Word document and use that as the data source. Are you seeing all 700 records listed in Mail Merge Recipients? It may be worth re-examining your database looking for hidden (and empty) rows. The way Word connects to Excel these days there should not be problems with "special characters" such as double-quotes, but it may be worth seeing if there is anything atypical in the data around row 249. Is your Excel workbook a .doc, docx/.docm? Does it make any difference if you save in the other format? Peter Jamieson http://tips.pjmsn.me.uk STOG wrote: I'm trying to make mailing labels in Word 2007 from an Excel 2007 database, but the merge ends at record 249 rather than the actual 700 records. I haven't had any problem doing this kind of merge before with longer recipient lists. I've checked the database which looks ok and tried starting over using mail merge. Any help would be appreciated. |
#3
|
|||
|
|||
Mail merge for labels
I tried saving the database as an xlsx, still didn't recognize anything more
than 249 records, which is the number that shows in "mail merge recipients." I can't see anything on the database around record 249 that's any different from the succeeding rows. There are no blank rows (which would have resulted in blank labels) mail merge simply doesn't see the rest of the database. I copied the database to a word document but mail merge couldn't use that format. "Peter Jamieson" wrote: I do not know what is wrong, but... As a workaround, you may be able to copy/paste the entire database into a Word document and use that as the data source. Are you seeing all 700 records listed in Mail Merge Recipients? It may be worth re-examining your database looking for hidden (and empty) rows. The way Word connects to Excel these days there should not be problems with "special characters" such as double-quotes, but it may be worth seeing if there is anything atypical in the data around row 249. Is your Excel workbook a .doc, docx/.docm? Does it make any difference if you save in the other format? Peter Jamieson http://tips.pjmsn.me.uk STOG wrote: I'm trying to make mailing labels in Word 2007 from an Excel 2007 database, but the merge ends at record 249 rather than the actual 700 records. I haven't had any problem doing this kind of merge before with longer recipient lists. I've checked the database which looks ok and tried starting over using mail merge. Any help would be appreciated. |
#4
|
|||
|
|||
Mail merge for labels
You can also try saving as .csv format and see if that makes any difference.
I think you may lose multiline data, i.e. line breaks may be removed. So far I have been unable to replicate this, but there might conceivably be a problem if you have large amounts of data per row - not just a large number of columns (although if you have more than 255, all bets are off as the columns beyond 255 can't get through), but lots of data per column. In any case, do you have more than 63 columns? In that case I think the edit-copy, edit-paste to Word will concatenate all the data from columns 64 onwards into column 63. Otherwise, it may be significant that the data will not copy/paste as a Word table is usually a reliable data source. Peter Jamieson "STOG" wrote in message ... I tried saving the database as an xlsx, still didn't recognize anything more than 249 records, which is the number that shows in "mail merge recipients." I can't see anything on the database around record 249 that's any different from the succeeding rows. There are no blank rows (which would have resulted in blank labels) mail merge simply doesn't see the rest of the database. I copied the database to a word document but mail merge couldn't use that format. "Peter Jamieson" wrote: I do not know what is wrong, but... As a workaround, you may be able to copy/paste the entire database into a Word document and use that as the data source. Are you seeing all 700 records listed in Mail Merge Recipients? It may be worth re-examining your database looking for hidden (and empty) rows. The way Word connects to Excel these days there should not be problems with "special characters" such as double-quotes, but it may be worth seeing if there is anything atypical in the data around row 249. Is your Excel workbook a .doc, docx/.docm? Does it make any difference if you save in the other format? Peter Jamieson http://tips.pjmsn.me.uk STOG wrote: I'm trying to make mailing labels in Word 2007 from an Excel 2007 database, but the merge ends at record 249 rather than the actual 700 records. I haven't had any problem doing this kind of merge before with longer recipient lists. I've checked the database which looks ok and tried starting over using mail merge. Any help would be appreciated. |
Thread Tools | |
Display Modes | |
|
|