-----Original Message-----
Hi Mary,

I'm creating a form that our clients can fill out in
Microsoft Word. I've been asked that our clients be
able
to print labels from this form as well, grabbing
information from a particular field on the form. The
field's name is "FieldNo." The label "FieldNo" is not
in
the first row of the form, it's half-way down the
page.
I don't want the clients to go through a mailmerge
process, I'd like them to be able to choose a button
that
says "Print Labels", and the labels will print. We're
going to use Avery 8160 for the labels. The client
will
enter 1 or more field nos. in the field no. column.
I'm
guessing I'll need to create a macro to do this, but
I'm
a macro rookie.

A couple of questions

1. Version of Word?

2. Is this a form created using the Forms toolbar, or
something else?

3. If you're in a regular document (not protected as a
form), does the Tools/Envelopes and Labels/Labels
command do
basically what you need?

Note: the correct place to get help on macros if you've
no
experience is the word.vba.beginners newsgroup.

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
:-)

.

Hi Cindy,

Thanks for the reply.

1. I'm using Microsoft Word 2002.
2. Yes, I created the form using the forms toolbar,
after downloading an example Template from Microsoft's
page.
3. The Envelopes/Labels command in a normal document
doesn't do exactly what I need. I have 5 text form
fields in a form (at some point there might be more) that
I need to generate 5 Avery 8160 labels for at the same
time. The fields are "Text1" - "Text5".
I've created a data source document that contains a table
with 1 column and 30 rows of data. The first row of data
(after the header row), is a field I've bookmarked. My
plan was to get the value of "Text1" from my form
document into the bookmark called "label1" in the first
field of the data source, and so on.
Then I'll use my data source to mail merge (hopefully
with a macro) with a main label document I've created
(Avery 8160). I don't know if this is the correct plan
of action or not, but so far I haven't done well. I have
problems with the bookmarks, saying the "range can't be
deleted". I think it's going to delete my bookmarks, and
when I try to type in code to avoid this, I have no
luck. I even have problems opening the data source from
a macro in the form (says I have the wrong path or file
name, even though I used the macro recorder to record the
macro). I haven't even gotten to the mail merge part
yet, because I can't get the data from the
bookmark "Text1" in the form to the bookmark "label1" in
the data source document, much less leave the bookmarks
in tact.
Thanks for reading my post.
p.s. What's the web address for the vba beginners site
you mentioned I should use? I tried typing in
www.word.vba.beginners newsgroup but that didn't work.
Thanks.