I am trying to create a page of labels with different addresses on them. Following various videos etc I have linked the word 2007 diocument to the excel spreadsheet. However, the addresses are too far to the left and are not lined up. I know how to change the spacing, but how do I line them up? I have a small picture in the top left-hand corner and cannot find how to select the text without the picture being selected also.
You may find it helpful if you zoom in to see the top left label only. You can then edit it like a normal word page - indents, etc and will probably find it easier to select just what you want, Then when you are happy zoom out and click on update all. For the picture you will need to set text wrapping.
Many thanks. I think that I am not understanding the fields secion. I have labelled the headings on the excel sheet as Title, Surname, Line 1, Line 2 etc. When I look at the mail merge recipients window, the fields are called after the top line of the addresses ie mr & mrs Smith etc! Does one have to use the titles which they specify?
I spent all of yesterday on this and am now going backwards!
It should come up with the headings that you put at the top of Excel. When you chose your source did you have "first row of data contains column headers" checked? Getting it right first time can be fiddly but after that it is worthwhile.
You appear to have selected "address block" rather than individual fields. Address block is a defined block which is often not what I want. Try selecting "insert Merge Field" on the Mailings tab ribbon.
How do I change from 'address block' to individual fields, Woolwell? Most of the options in the ribbon seem to be greyed out. I have saved so many new files with different names! I have one with just the <address block> and <next record>; and several with part-addresses and the wrong layout.
Also, when I go to 'edit recipient list' the resulting window has Data Source, 'and family', Smithy Road, My Town, etc at the top, instead of the correct headings. Is there somewhere in the excel worksheet options to show or hide the top line, I wonder? I can't find it.