use vba userform to enter data in excel and print in word avery template RRS feed

  • Question

  • Using excel/word 2010. Have vba userform to accept input of 5 fields/record. Then, need to print on Avery template through word. Must create label data first, then import to word - where the Avery label template layout is provided by an Avery Wizard. Cannot use Access. Must be excel and word. Users will create their customized labels through a vba userform. Then, press print button on userform to produce labels. I understand and have tried mail/merge, I just don't know how to translate that into vba code for processing.

    Thank you for your assistance. Hopeful answer is out there.

    Thursday, July 25, 2013 7:25 PM