Mail Merge Question
 

Hello -

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. For some reason... it's merging
PAST the values I specify to fill up the last page. What gives?

FNORD

For help on Word mail merge using Excel as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben Excel MVP

On Mon, 7 Feb 2005 10:11:30 -0800, "FNORD"
wrote:

Hello -

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. For some reason... it's merging
PAST the values I specify to fill up the last page. What gives?

Hello -

Thanks for your help, but those are giving me directions on how to do a mail
merge, which I already know how to do. When I merge it.... it merges just
fine, but goes PAST the numbers I specified in the range and will fill up the
rest of the page. It never used to do this.


"Gord Dibben" wrote:

FNORD

For help on Word mail merge using Excel as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben Excel MVP

On Mon, 7 Feb 2005 10:11:30 -0800, "FNORD"
wrote:

Hello -

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. For some reason... it's merging
PAST the values I specify to fill up the last page. What gives?

Perhaps trying it with only one worksheet in the workbook
would get different results.

Do you have hidden rows. Meaningless to Mail Merge.

Did you have Filtering in effect before. Mail Merge only sees
what the filter allows you to see. .

You say you are using (excel 2002 SP3) -- and you say results are
not what you used to get. What if anything has changed since when it worked.


"FNORD" wrote ...
Thanks for your help, but those are giving me directions on how to do a mail
merge, which I already know how to do. When I merge it.... it merges just
fine, but goes PAST the numbers I specified in the range and will fill up the
rest of the page. It never used to do this.