printing labels from a form using a macro

[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. Can anyone help me with this? Thank
you!

 

[Cindy M -WordMVP-]

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

 

[Mary]

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

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.

 

[Mary]

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

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.

 

[Cindy M -WordMVP-]

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/microsoft.public.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

 

[Doug Robbins]

Hi Mary,

It will be easier for us to help you if you copy and paste the code of the
macro that you have developed into a message that you post back here.