How to create duplicate labels with mail merge?

Using Office 2003, have a SS with addresses, have merged into word to create
mailing labels works fine....I need to create membership labels....2 of the
same address to a row....is there a way to merge the SS into word without
creating duplicate rows in the SS...This is a huge membership list.

Try this:

Select a two column label format in Word mail merge.

In first pair of labels enter Name & Address Fields (removing "Next Record"
control field)

In the next (second) pair, keep the "Next Record" control field in the first
label, adding the name & address details; in the second label just put the
name & address details.

Repeat the second format for the rest of the sheet.


HTH



"Beth" wrote:

> Using Office 2003, have a SS with addresses, have merged into word to create
> mailing labels works fine....I need to create membership labels....2 of the
> same address to a row....is there a way to merge the SS into word without
> creating duplicate rows in the SS...This is a huge membership list.

It worked!!!! Thank you, thank you, thank you!!!
You have saved me so much time!
Really appreciate it!
Beth

"Toppers" wrote:

> Try this:
>
> Select a two column label format in Word mail merge.
>
> In first pair of labels enter Name & Address Fields (removing "Next Record"
> control field)
>
> In the next (second) pair, keep the "Next Record" control field in the first
> label, adding the name & address details; in the second label just put the
> name & address details.
>
> Repeat the second format for the rest of the sheet.
>
>
> HTH
>
>
>
> "Beth" wrote:
>
> > Using Office 2003, have a SS with addresses, have merged into word to create
> > mailing labels works fine....I need to create membership labels....2 of the
> > same address to a row....is there a way to merge the SS into word without
> > creating duplicate rows in the SS...This is a huge membership list.

Beth,
Glad to hear it solved your problem and thank you for the feedback.

"Beth" wrote:

> It worked!!!! Thank you, thank you, thank you!!!
> You have saved me so much time!
> Really appreciate it!
> Beth
>
> "Toppers" wrote:
>
> > Try this:
> >
> > Select a two column label format in Word mail merge.
> >
> > In first pair of labels enter Name & Address Fields (removing "Next Record"
> > control field)
> >
> > In the next (second) pair, keep the "Next Record" control field in the first
> > label, adding the name & address details; in the second label just put the
> > name & address details.
> >
> > Repeat the second format for the rest of the sheet.
> >
> >
> > HTH
> >
> >
> >
> > "Beth" wrote:
> >
> > > Using Office 2003, have a SS with addresses, have merged into word to create
> > > mailing labels works fine....I need to create membership labels....2 of the
> > > same address to a row....is there a way to merge the SS into word without
> > > creating duplicate rows in the SS...This is a huge membership list.