M
Michael to Ed
How do i put more than one client on a Mailing Label. the Label is not
actually for posting through the mail
actually for posting through the mail
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Vinson
How do i put more than one client on a Mailing Label. the Label is not
actually for posting through the mail
You'll have to provide some more information, Michael. Are you doing
this with Microsoft Access? What is your table structure? YOU can see
your database - we cannot.
In a nutshell, you would create (or modify) a Report to fit the
"mailing label" paper size, based on a query which returns the
information that you want to print. You're not going to find the
Report Wizard able to do this for you; you'll need to customize it.
John W. Vinson[MVP]
M
Michael to Ed
thank you for your reply.
yes, i am in Access and have a Table with client names and details. i wish
to put up to four names on a single Label, with 5 other detail items. it will
all fit on one Label. at the bottom of each label i would like to have a
little box with some last minute info, which i wish to enter as the Query
starts to run. The labels I use are APLI ref. 01275. 14 labels to a A4 sheet,
each label 105 x 40 mm.
i would like to therefore have two columns per page to suit.
Your assistance is greatly valued
Michael
yes, i am in Access and have a Table with client names and details. i wish
to put up to four names on a single Label, with 5 other detail items. it will
all fit on one Label. at the bottom of each label i would like to have a
little box with some last minute info, which i wish to enter as the Query
starts to run. The labels I use are APLI ref. 01275. 14 labels to a A4 sheet,
each label 105 x 40 mm.
i would like to therefore have two columns per page to suit.
Your assistance is greatly valued
Michael
J
John Vinson
thank you for your reply.
yes, i am in Access and have a Table with client names and details. i wish
to put up to four names on a single Label, with 5 other detail items. it will
all fit on one Label. at the bottom of each label i would like to have a
little box with some last minute info, which i wish to enter as the Query
starts to run. The labels I use are APLI ref. 01275. 14 labels to a A4 sheet,
each label 105 x 40 mm.
i would like to therefore have two columns per page to suit.
Your assistance is greatly valued
Again... you'll need to create a Query which returns the data that you
wish to print on the labels, and then create a Report to arrange that
information on the paper. The wizard isn't going to be able to do this
for you, you'll need to do it yourself. Use the File... Page Setup
menu option to specify the 14-to-a-sheet layout and the size of each
label (in millimeters if that's your system setting).
The "little last minute box" could have a control source such as
=Forms!MyFormName!txtLastMinute
to display whatever is entered into that form control.
John W. Vinson[MVP]