HI Mary

Sorry for the very late response, but I've been busy
recently and haven't had lots of "brain capacity" for
questions that require a lot of thought. It also doesn't
help that your reply is at the very bottom when I "flash
through" the unread messages.

Taking the first, and simple question, first:

What's the web address for the vba beginners site
you mentioned I should use?

Try:
news://msnews.microsoft.com/microsof...word.vba.begin
ners

Beyond that, you do know that a set of labels is really
just a table set out to emulate a label sheet, right?

So, as long as you're needing to pull the data from a form
field, rather than put it into a data source table, then
perform a mail merge, why not write it directly into the
label sheet (table in a Word document)?

The syntax to pick up information from a text form field
is:

sStringVar =
ActiveDocument.Formfields("Textboxname").Result

I'm sure this doesn't answer all your questions, but it at
least gives us a place to start...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)