I want to make name badges for a conference. I have successfully merged my
(Excel)database with my main (Word 2000)document and have formatted the
mergefields in the first label. How do I apply the same formatting to the
remaining (188) labels without going to each and every label?

You should apply the formatting to the mergefields before completing the
merge.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Notatechie" wrote in message
...
I want to make name badges for a conference. I have successfully merged
my
(Excel)database with my main (Word 2000)document and have formatted the
mergefields in the first label. How do I apply the same formatting to the
remaining (188) labels without going to each and every label?

Add a NEXT record field to the start of the first cell. Select the first
cell. Copy to the clipboard. Select the table and paste.
Remove the NEXT record field from the FIRST cell only. Merge away!

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Notatechie wrote:
I want to make name badges for a conference. I have successfully
merged my (Excel)database with my main (Word 2000)document and have
formatted the mergefields in the first label. How do I apply the
same formatting to the remaining (188) labels without going to each
and every label?

Hi ?B?Tm90YXRlY2hpZQ==?=,

I want to make name badges for a conference. I have successfully merged my
(Excel)database with my main (Word 2000)document and have formatted the
mergefields in the first label. How do I apply the same formatting to the
remaining (188) labels without going to each and every label?

Only Word 2002 and later versions provide a way to automatically copy the
first label to all other labels of the main merge document. In Word 2000 you
have no alternative than copying the first label and pasting over every other
label in the main merge document.

If you're talking about the merge result, then you will need to go to each
label, individually. You can try recording the actions for a single label in a
macro. Depending on what kinds of formatting changes you're making this may or
may not help save time.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)