Can I print a single mailing label from a report in access?

[Guest]

I want to print single mailing labels from a database of orders. Right now I
can only figure out how to print a whole sheet of labels each time I print
from a report that I created in the label wizard. As orders for my product
come in randomly it would be better for me to be able to print out a single
label, corresponding to a specific record of a specific order, or a set
number of labels each one corresponding to a specific order or record. Any
help on this problem would be greatly appreciated. Thank you.

 

[Ilan]

I would reccomend doing this via a query and a macro which
goes to word. i just answered a similar question to
someone else on the tabledesign page. if you set up your
report to pull from a new query, in the customerId field or
name or something, in the criteria line put in:
[Enter Your Text Here]

By putting those brackets in, a pop up will run prompting
the user for whatever you put in in the brackets. So if in
your criteria for userId (For example), you could do this:

[Please Enter the User ID]

When you run the query, a pop up asking that question will
come up and you can type in the User ID#, which will only
store that number in the query. From there, since the
report will be tied to the query, the report will only run
with the one record (Although when you open the report,
you r pop up will come up again).

If that doesnt help, here's my long explanation of going
through a form and word that i posted as a response on
tabledesign:


Hello,
you are in luck, i have done the same thing. First of
all create a macro with the action "RunApp." Then in the
command line, enter the directory extension for Microsoft
Word (It can be found through start --> run. It looks
something like this:
"c:/program files/office10/winword.exe").

Directly after the directory for Word, enter the
directory location for the document. Again - something
like this:
"c:/my documents/document1.doc"

Save the macro.

Go into the form design view and open the toolbox. From
there create a new command button. The wizard will come
up and under categories, select misc. and in the right
hand column click run macro. From there, follow the
steps for the command button to be linked to macro you
just created.

NOW, go to the query that is attached to the Word
document. In the criteria for one of the fields
(preferably an id field or something like that) Write the
following code:

[Forms]![NameOfForm]![NameOfField]

Mine looked something like this:
[Forms]![Client_Info]![ID]

So after all that, if you go to your form and click the
new button you made, it should pass all your info to word
and then all you have to do is merge it and you will get
your one record.

Hope some of that helps,
Ilan