[lgewirtz]

I'd like to use the Labels tab in the Envelope and Labels dialog box (DialogToolsCreateLabels) in 1 of 2 ways -

scenario 1 - macro collects user info for address, inserts it into address field, clicks on options button so user can choose label, then macro automatically continues on by clicking on New Document button and then finishes up work on the document that is created.

scenario 2 - macro has it's own userform which will show the list in the labels option, let's me collect the answer in a variable which I feed into the statement: Application.MailingLabel.CreateNewDocument _
Name:=<INSERT VARIABLE HERE>, Address:=addr, ExtractAddress:=False

I'm working in Word 2003. Any help appreciated!

Liz

[Ziggy1]

I'm not sure if you are asking for something that integrates with a particular spreadsheet or process....but I've used the Avery Wizard for years. It is a free download that Integrates with MS Office, you get a Avery Icon added, when you run it you can use listed from Excel or just fill in manually. Avery is a common Label mfg. but you can easily find the right template using generic store brand labels.