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

Thanks, but the problem is that I'm getting extra data....not losing or
missing data.

Anymore help would be appreciated. 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





Expand AllCollapse All

Have you posted your question in the Word MailMerge newsgroup? Someone
there may be able to help you solve the problem.

FNORD wrote:
Thanks, but the problem is that I'm getting extra data....not losing or
missing data.

Anymore help would be appreciated. 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