Tricky Macro Question

[Noerd Joeller]

Hi. I have a Word 2003 Macro question if typing 5000 postcards. There
are 5000 names, but only about 100 addresses (that means about 50
different people's names per unique address) What would be the "fastest
most efficient" Macro to do this? Here is example:

Name One
333 Bird Street
City, Bigstate 12345

----page break (next post card) ---

Name Two
333 Bird Street
City, Bigstate 12345

----page break (next post card) ---

Name Three
333 Bird Street
City, Bigstate 12345

----page break (next post card) ---

....then, about 50 names later

Another One
555 Giraffe Place
City, State 33333

----page break (next post card) ---

Another Two
555 Giraffe Place
City, State 33333

 

[Jezebel]

Set up the list in Excel, then use that for a mailmerge.

 

[Westcoast Sheri]

Set up the list in Excel, then use that for a mailmerge.

no, need macro help for word. Thanks.

 

[Jay Freedman]

no, need macro help for word. Thanks.

Since you didn't say anything about where the names and addresses come
from or how the macro should know which names go with which addresses,
there's nothing much to say. In any case, a macro is *not* going to be
the "fastest, most efficient" method -- at best it will be reinventing
the mail merge wheel.

Is this a homework exercise? Is that why you're insisting on a macro?