MAIL MERGE PROBLEMS

Hello -

I'm very familiar with how to do mail merges....but when I do a mail merge
from our excel database (excel 2002 SP3) to Word.. (word 2002 SP3) to create
labels, I have to specify which values I want to use because I don't want to
use them all (ex: merge 1000-2000) For some reason... it will merge up to
the last number I specify... but then it will go PAST that number just enough
to fill up the last page.

It never did this until fairly recently. Actually I think it started when
we upgraded from 2000 to XP. The original excel database was created when we
used 2000. When I use my original templates that I created in word 2000, it
does not do this. But if I start a brand new label template in Word and
connect it to my excel database to merge... it gives me this problem.

I REALLY need to rectify this problem.

Any advice would be great. Thanks!

Word MVP Cindy Meister has mail merge information on her web site:

http://homepage.swissonline.ch/cindy...r/MergFram.htm

Look for "Mail merge loses Excel data"

FNORD wrote:
> Hello -
>
> I'm very familiar with how to do mail merges....but when I do a mail merge
> from our excel database (excel 2002 SP3) to Word.. (word 2002 SP3) to create
> labels, I have to specify which values I want to use because I don't want to
> use them all (ex: merge 1000-2000) For some reason... it will merge up to
> the last number I specify... but then it will go PAST that number just enough
> to fill up the last page.
>
> It never did this until fairly recently. Actually I think it started when
> we upgraded from 2000 to XP. The original excel database was created when we
> used 2000. When I use my original templates that I created in word 2000, it
> does not do this. But if I start a brand new label template in Word and
> connect it to my excel database to merge... it gives me this problem.
>
> I REALLY need to rectify this problem.
>
> Any advice would be great. Thanks!
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html