labels from mail merge

[Ralph Smith]

I have a list of addresses in MS Excel that I have sucessfully linked
to a mail merge in MS Word.

I would now like to be able to have the addresses appear 4 times each
in a row and then the next address and so on...something like this:

Address1 Address 1 Address1

Address1 Address2 Address2

Address2 Address2 Address3

Address3 Address3 Address3



Thanks in advance for any help.

 

[Pegasus \(MVP\)]

Sounds like an ideal question for a Microsoft Word newsgroup.

 

[Simon Chambers]

I don't think that you can do this directly, however I can think of a couple
of work-arounds:

1. Use a macro to duplicate your source worksheet, copying each row 4 times.

2. If you can use Access instead of Excel, have the data in a table, but use
a query that repeats each row 4 times (eg using a join) as the source.

Simon