View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Craigm Craigm is offline
external usenet poster
 
Posts: 2
Default Mailmerge labels excel 07 to word 07

,Having trouble merging an excel 07 spreadsheet with four columns, 205
records to labels in word 07. works ok through page layout. I have selected
avery 5161 (20 labels to a page) as the label type. After selecting my
recipient document a page is populated except for the top left corner with
Next Record at each label start. I place my field names in the first
label. When use 'Update labels' only the top and bottom rows are filled in.
Completing the merge all the way through printing, still only prints labels
at each corner instead of the 20 / sheet. After reading other problems here I
have tried copying my data source to new spreadsheet, copying to a word table
nothing changes. Copy and paste the labels from the first row to other rows
doesn't work either. Any ideas out there?