Consulting

Results 1 to 2 of 2

Thread: Clever Mailmerge of data in XL

  1. #1
    VBAX Newbie
    Joined
    Jun 2006
    Posts
    3
    Location

    Question Clever Mailmerge of data in XL

    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.

  2. #2
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    Check out this thread dealing with making labels from excel....might be what you need:
    http://vbaexpress.com/forum/showthread.php?t=9069
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •