View Single Post
  #4   Report Post  
Mary
 
Posts: n/a
Default


-----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.