what are all the various mailing label types

[Dan777]

Forgive me if you think this shouldn't be in this form, but it is in fact about VFP automation.

I'm creating a feature in my VFP app to create mailing labels. The data for the labels comes from SQL, thru VFP, then exported to Word via automation. Everything works fine. Now I just need to know what the various label types are that end users may need to print on. Word has this "MailingLabel.CreateNewDocument" method. The first param of that method is the label name, i.e. for the 8160 Avery labels it'd be:

oWord.MailingLabel.CreateNewDocument("8160",...)

but then for the Avery 2160 minilabels there's
oWord.MailingLabel.CreateNewDocument("2160 mini",...)

and for some self-adhesive-labels it's:
oWord.MailingLabel.CreateNewDocument("Self Adhesive Tab 1 1/2",...)

So what are all the various label names? I found a dbf called 'labels.dbf' in c:\microsoft visual foxpro 9\tools\addlabel, but that doesn't include all of the label types.

I could go to Avery's web site and get a list of all the various label types, but then of course is the issue of what are the correct values that Word is expecting for each?

Thanks much,
Dan

 

[dgrewe]

More then I want to count. Check out

http://www.avery.com

David W. Grewe Dave

 

[TamarGranor]

You're definitely _not_ looking for labels.dbf. That's for the VFP Label Designer.

To see the list of labels available in Word, open Word, choose Tools | Letters & Mailings | Envelopes and Labels. Click Options and you'll see the list of labels. It looks like you use everything up to the hyphen to specify the label type.

It's possible that you can get at this list through Automation, but I don't have time to dig into that right now. You might try starting from the application object to see what you can find.

Tamar