Print splitting...
 

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

Print splitting...
 

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?

Print splitting...
 

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

Print splitting...
 

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

Print splitting...
 

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

Print splitting...
 

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