Probably the easiest would be to use the Microsoft Word Mail Merge or
Envelop options under the Tools menu ( then Letters and Mailings in word
2003) I believe. You can cite your Excel Data as the source.

This will be much more robust than any macro in Excel.

--
Regards,
Tom Ogilvy


"EricRain" wrote in
message ...

Hi!
I need a simple peace of code:
I have a xls with huge list with adress, names postal codes etc., and I
need to to split it to print on envelopes, sample like: take first row;
col a., - row xx colyy; col b rowx1y1; etc.; print; goto row+1;
repeat.till end of string.

Have anybody ide how to do this, or (I guess it exist) have someone
seen script like this in the net ???

Please give me some advice.

Respectly: Eric Rain


--
EricRain
------------------------------------------------------------------------
EricRain's Profile:
http://www.excelforum.com/member.php...o&userid=24485
View this thread: http://www.excelforum.com/showthread...hreadid=380845