Data merge to labels difficulty

D

djln5

I am using data merge to print labels off address information in an
Excel spreadsheet.

I have approximately 110 names and addresses to merge, but I can only
get one page (which is 30 names and addresses). These print out great
but that's all I can get.I have indicated the whole worksheet, yet
somehow the data doesn't merge in (other than the first 30 =one page
of address labels).

When I hit the preview, it only shows that 30 there as well.

Any thoughts??
 
D

Daiya Mitchell

I'm pretty sure that you hit the Preview button instead of the Merge
button. They are both down at the bottom of the merge palette--Preview's
got an ABC on it, but it's not the one you want, as it only produces 1
page of results. Hit the Merge to New Document icon instead.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Populate One Pages from spreadsheet 0
Mail merge labels 8 per page, but 84 is not divisible by 8 3
Mail Merge Directory Conditional Page Break 0
Mail Merge Help 1
Grouping Names in Mail Merge 0
Mail merge & labels - problems with multiple sheets 1
Mail Merge Makes One Page of One Name of One Label Instead 1
A way to mail merge from excel into a word label template? 0

Top