View Single Post
  #3   Report Post  
TChristian
 
Posts: n/a
Default

Hi Jeanie,

Make sure your columns contain headers and that you have specified the Print
Area of the data you wish to be captured in the merge. Otherwise Excel
exports all empty cells and you end up with numerous blank pages of labels.

"Jeanie" wrote:

I am trying to create labels from an excel spreadsheet containing names and
addresses. I use the mail merge wizard in word. I should end up with 3 and a
half sheets of labels (30 labels to a sheet). Instead, I'm ending up with
125 as it is putting one record on each page!

Help!