Hi,

I have a Workbook that contains a list of Names and Addresses, I have
already written a macro that when actioned takes the details from a
selected record (user defined) exports to a linked Word document and
prints it (thanks to all who helped me with that).

The next stage is to print address labels......

Currently the labels I use are the classic A4 3 x 4 self adhesive type
but I dont know how to either "save up" the details so I dont use a
complete sheet everytime I print, or how to get it to recognise if a
"cc" cell in the worksheet is active and therefore has to print an
additional label for that record.

To summarise I want to....

1. "Save up" multiple addresses and once I either have 12 automatically
print or when the user actives a "trigger" print however many there are
to date.
2. Print duplicate labels (c/w different names) when a record has
multiple names in certain cells of it.

I am currently thinking of doing all the above in a worksheet rather
than trying to link across to Word, but any ideas or input would be
very welcome.

Thanks,

Alec.


--
Alec H
------------------------------------------------------------------------
Alec H's Profile: http://www.excelforum.com/member.php...o&userid=31042
View this thread: http://www.excelforum.com/showthread...hreadid=517718