|
| View previous topic :: View next topic |
| Author |
Message |
Guest
|
Posted: Sun Dec 16, 2007 9:29 am Post subject: help with labels |
|
|
hi
i have a simple excel sheet containg about 100 names & addresses which
I have used yearly to mail merge in word to print labels ( 21 per
sheet). I have never had any problems in the past but this tear
everytime I complete the mail merge it only shows the first sheet 21
labels. At the bottom it also says Page 1/1. Obviously there should
be five sheets. This is driving me nuts. The excel sheet is just the
standard one I have used every year. - NAME, ADDRESS1, ADDRESS2 etc
along the first row.
Can anyone help me? |
|
| Back to top |
|
 |
Google Sponsor

|
Posted: Sun Dec 16, 2007 9:29 am Post subject: Advertisement |
|
|
|
|
| Back to top |
|
 |
Suzanne S. Barnhill Guest
|
Posted: Sun Dec 16, 2007 3:07 pm Post subject: Re: help with labels |
|
|
You haven't completed the merge; you're just previewing it. You must use
either Merge to New Document or Merge to Printer.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
<craiganderson20@googlemail.com> wrote in message
news:0ee8ecbf-1e8f-4e11-8f31-b4647fe7ad4c@s19g2000prg.googlegroups.com...
| Quote: | hi
i have a simple excel sheet containg about 100 names & addresses which
I have used yearly to mail merge in word to print labels ( 21 per
sheet). I have never had any problems in the past but this tear
everytime I complete the mail merge it only shows the first sheet 21
labels. At the bottom it also says Page 1/1. Obviously there should
be five sheets. This is driving me nuts. The excel sheet is just the
standard one I have used every year. - NAME, ADDRESS1, ADDRESS2 etc
along the first row.
Can anyone help me? |
|
|
| Back to top |
|
 |
Guest
|
Posted: Mon Dec 17, 2007 8:26 am Post subject: Re: help with labels |
|
|
On 16 Dec, 15:07, "Suzanne S. Barnhill" <sbarnh...@mvps.org> wrote:
| Quote: | You haven't completed the merge; you're just previewing it. You must use
either Merge to New Document or Merge to Printer.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
craiganderso...@googlemail.com> wrote in message
news:0ee8ecbf-1e8f-4e11-8f31-b4647fe7ad4c@s19g2000prg.googlegroups.com...
hi
i have a simple excel sheet containg about 100 names & addresses which
I have used yearly to mail merge in word to print labels ( 21 per
sheet). I have never had any problems in the past but this tear
everytime I complete the mail merge it only shows the first sheet 21
labels. At the bottom it also says Page 1/1. Obviously there should
be five sheets. This is driving me nuts. The excel sheet is just the
standard one I have used every year. - NAME, ADDRESS1, ADDRESS2 etc
along the first row.
Can anyone help me?- Hide quoted text -
- Show quoted text -
|
Thats what I initailly thought but it makes no difference even when I
complete the merge. |
|
| Back to top |
|
 |
Suzanne S. Barnhill Guest
|
Posted: Mon Dec 17, 2007 3:44 pm Post subject: Re: help with labels |
|
|
Version of Word?
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
<craiganderson20@googlemail.com> wrote in message
news:c1d954f4-3db6-4de5-8951-8c02db066763@a35g2000prf.googlegroups.com...
| Quote: | On 16 Dec, 15:07, "Suzanne S. Barnhill" <sbarnh...@mvps.org> wrote:
You haven't completed the merge; you're just previewing it. You must use
either Merge to New Document or Merge to Printer.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
craiganderso...@googlemail.com> wrote in message
news:0ee8ecbf-1e8f-4e11-8f31-b4647fe7ad4c@s19g2000prg.googlegroups.com...
hi
i have a simple excel sheet containg about 100 names & addresses which
I have used yearly to mail merge in word to print labels ( 21 per
sheet). I have never had any problems in the past but this tear
everytime I complete the mail merge it only shows the first sheet 21
labels. At the bottom it also says Page 1/1. Obviously there should
be five sheets. This is driving me nuts. The excel sheet is just the
standard one I have used every year. - NAME, ADDRESS1, ADDRESS2 etc
along the first row.
Can anyone help me?- Hide quoted text -
- Show quoted text -
Thats what I initailly thought but it makes no difference even when I
complete the merge.
|
|
|
| Back to top |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|