-----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 again Cindy,
I just wanted to tell you I've made some progress since
the last post. I have my datasource opening from a macro
in my form, and I have the values of the
bookmarks "Text1"-"Text5" in the form being sent as the
values of "label1"-label5" on the datasource. The data
comes across into the datasource document as "FORMTEXT"
followed by the value, so I'll have to find a way to
strip "FORMTEXT", then actually merge my datasource into
labels, but at least I'm getting somewhere.