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

EricRain wrote:
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 ???

You could use MS Word and do a mail merge with your excel list as the source
data.

or maybe I'm misunderstanding the question?

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

Mailmerge in MS word can do this, it does have option to take data fro
exce

--
anilsolipura
-----------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627
View this thread: http://www.excelforum.com/showthread.php?threadid=38084

Nope I need a bit different thing. So, I have :
|Name|Adress|Code|
|Name|Adress|Code|
|Name|Adress|Code|

ANd I need to split it in a way like that:

|Name |Name | Name |
|Adress|Adress|Adress|
|Code |Code |Code |

To print on a sticks... Any ideas ????


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

Comeone , I realy need your help.... Maybe something

--
EricRai
-----------------------------------------------------------------------
EricRain's Profile: http://www.excelforum.com/member.php...fo&userid=2448
View this thread: http://www.excelforum.com/showthread.php?threadid=38084