PDA

View Full Version : Clever Mailmerge of data in XL



jdmils
09-17-2006, 10:56 PM
My aim is to create lables for parts which come in from suppliers.

I have created an Excel workbook to store the definitions of the parts and the QTDs ordered & supplied in this format:

.................................................. ...................................... Order Qty....... Rxd..........Oustanding
.................................................. ...................................... Date.............. Date
Make......Model......Cartridge......Printhead..... .Colour......User......13/09/2006......18/09/2006

The headers start in row 3.

I have created a Word doc formatted to the labels I want to print. I want to print X labels, where X is the number in the Rxd column for each row. Is this possible? How?

Office 2003.

lucas
09-18-2006, 06:29 AM
Check out this thread dealing with making labels from excel....might be what you need:
http://vbaexpress.com/forum/showthread.php?t=9069