ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel - Mail Merge (https://www.excelbanter.com/excel-discussion-misc-queries/188164-excel-mail-merge.html)

Josephine

Excel - Mail Merge
 
I am merging selected recipients from an excel document to labels. Everything
from selection of recipients to final merged label document appears
fine...but there's always info. missing. Problem is Label Sheet has 16
individual labels, but 17th recipient is always missing, the next 16 records
merge ok and then the next recipient is missing, yet I cannot find an error
or an answer why. Has anybody had this problem and have they found a
solution to it?

Bruce Sinclair

Excel - Mail Merge
 
In article , ?B?Sm9zZXBoaW5l?= wrote:
I am merging selected recipients from an excel document to labels. Everything
from selection of recipients to final merged label document appears
fine...but there's always info. missing. Problem is Label Sheet has 16
individual labels, but 17th recipient is always missing, the next 16 records
merge ok and then the next recipient is missing, yet I cannot find an error
or an answer why. Has anybody had this problem and have they found a
solution to it?


Nope. Are you merging to labels using word and using XL only as the data
source, one 'record' to a line ? If not, try that.
If you are ... well, turning double sided printing off solved a number of
apparently unrelated errors for me. :) Check your printer settings ?

HTH.



All times are GMT +1. The time now is 08:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com