Help with advanced VBA & Word

[RickyZ]

I'm trying to do something for work, in which it will print labels that go on
boxes to be shipped out. It's going to be a 4x6 label that prints on a
thermal printer. Anyway, my idea is for someone to be able to click a link
from the desktop, and have a document ask them for three pieces of
information: the customer name, the invoice #, and the number of packages.
From this I would like it to create the 4x6 label with our company logo,
address, and phone #...along with the users information. I would then like
it to print the amount of labels equal to the amount of packages the user
said they had. I know a little about this advanced stuff...and right now I
have a Word template, that when opened it asks the user the three pieces of
information...and creates the label. I'm looking for help in getting it to
print the correct amount of labels to the correct printer and close the
document if possible. I created the template by designing the label, and
putting in "FillIn" fields, then protected the document so that only forms
can be filled in. I have the document set okay as it seems, the user enters
the data and it displays the label...the only thing they can edit is the 3
fields. Anyone that is interested in helping...I will give points to the one
that helps me with the solution. Also, for those with more experience then
me, if there is a better way to accomplish this please let me know, I'm open
for options, I just want this to work as explained to make it very simple.
Let me know if you need more info...also the document template I have created
is available here: ftp://Expert:[email protected]/LabelPrint.dot

 

[dz]

Hoo boy. Well, I'll help you out as much as I can, but
it's going to take some back and forth. I'm not too
comfortable with going to the ftp site and not being able
to virus check the download first.

So, please send the file to me via email at (e-mail address removed).
Also, if the template doesn't have the Avery label
type/number in it, please include that for me also.

The bottom line is that you need to create a "new"
document from the label itself. Then save it for future
use.

Then each time the user accesses the template, it creates
a datasource document from the user's responses and saves
over any existing one. Then you merge the main label
document with the datasource doc and that will print the
exact number of labels that you need, depending on the
label set-up. Sending it to the correct printer is fairly
easy.

It's involved. So, we probably should do this via email.