I need to re-open this query as I haven't resolved it earlier. i'll try to redefine my problem. I have a worksheet with 13 columns containing info like a. PRINCIPAL, b. SCHOOL c. TYPE d. DIST e. CIRC f. WARD, etc. Before I included the column PRINCIPAL some labels I had created in Word with this worksheet as my resource document, only showed the word PRINCIPAL in it. In my sample label I had to manually write it in. I then created an extra column called PRINCIPAL. My labels now have blank cells and a lot of them I must add. Yet the number of labels are correct, no names have been left out. How is this possible? Please assist. Regards Dawie

Hi Send me a sample of the dataset and I'll have a look at it and tell what label size you are trying to print to. In the land of the blind the one eyed man is king

Take it from start. U open ur master doc in word and have a copy of it. Ur file in excel, must be at 1st line "name of fields" i mean 1 row=1 field name (column a = name; column B = adress, and so on..). Regarding to the fields names, u've got ur mailing datas, begining a line 2. Each column MUST have a field name on 1st line. In word, u choose mailing . master doc? doc in use. Datas coming from? excel sheet, open ur sheet, choose "whole sheet". So ur fields name automatically come in the mailin tool bar, to be placed in ur master word doc. Care : it works only if fields name are not empty on 1st row, and mailing labels are not actualized when excel file is modified. If u modify/add a field in excel, u must take the mailing proceed from begining in word...Please report.

Hi Taxi. Yes I more or less went about it the way you described it with one exception. When asked what I want to select I chose "MyRange" in stead of the whole sheet. Do you think that could cause blank labels? Dawie

i always do it this way, i mean the whole sheet, even if i don't want other fields... Sometimes it's necessary to have a copy of ur excel sheet which contains only mailing labels u want, but unless it works perfectly. Don't forget there's no actualisation in fields names in word when added in excel.I think the most imortant is that u've got no blanks in the first line of ur rows selection.

Hi I got your email and have identified the problem. Click on the first row of your work sheet and then got to Data >> Filter >> Autofilter You will now be able to see all the previously hidden records where the Principal field is empty. Complete these empty fields and your blanks should disappear. HTH In the land of the blind the one eyed man is king

and in the land of nolegs men the one leg man is his joker...