Discussion Locked

Access 97 Multiple Labels

0 helpful
12 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a membership database in Access 97. I print a Custom Size Label with NO problem. But I require 2 labels for EACH MEMBER and they MUST BE side by side. In other words, print 2 Labels across for Member # 1 then print 2 Labels Across for Member # 2. The Labels that I use are 2 Across by 3 down (6 per page)

I hope someone has already done this and can help me out.....
Thanks!!!

Alan

12 replies

by dklippert

Do the merge in Word with Access as the source. When the Wizard is finished, Select the document and press Alt+F9.
This exposes the fields. Delte the {NEXT} fields in the right hand column. Alt+F9 restores the merge fields. You'll now have duplicates on each row.

by mra2

The people I'm dealing with need just ONE program. I don't want to use word also. But good reply! Thanks

by timfox

Merging into Word does provide a wealth of options when creating labels, but surely this be done with a regular Access report by duplicating the necessary fields across the page using appropriate spacing.

I guess your solution depends on whether you need to use Word's additional inbuilt support for producing labels or whether you want to setup the page yourself with an Access report. The Access report may give you an easier path depending on the level of automation you want.

Hope it helps
TimFox

by mra2

Your one the right path but Bob Sellman really detailed it. I think you helped everyone else zero in on this for me! Thanks!

by kees.valkenswaard

Actually there are two main approaches to your question. I will expand both, although I prefer the solution involving Word.

Make sure that all required details are available in one table or in one query. I assume you know how to make a query based on fields in one or more tables. It you have more fields than required for the labels, no problem. You will just not use these fields in the label setup.

First using Access only.
Use Report, Label Wizard, based on MyAdresses [either the table or the query. The name is just an example]
Choose the fields you require, use Return or Spaces where appropriate. Make certain to use the correct label types [size etc.]

If you can not find what you need, either adapt an existing type, make a new one or a copy of one already existing or made. Look very careful at all options. It would not be abnormal to have to do it several times before you have the size you want.

Another drawback is that in principle you have only one format for the complete label.
Having finished it you end up with the apparently wrong result, i.e. two different labels in one horizontal row.
Do not worry. I still do not recommend this approach, but it can be done.

Open the report in design view. Perhaps to your surprise there is only one label in the report.
By the way, before doing all this, make certain that you had selected the correct paper size.
Now, enlarge the grid of the report [in design view] to the width of a full page. The height should be OK by the wizard. Do, however, show no surprise if everything would not be printed correctly, due to the [non-printable] margins, which are different for each printer.
Select all fields on the report form [They probably contain formulas with the trimfunction]
Either drag through the left bar to select all fields, or click the first one, hold SHIFT down, click the next one until you have them all.

by kees.valkenswaard

Copy to the clipboard. Click somewhere else and paste.
Drag the [still grouped] fields to the right of the original fields and at the same height.
If you are lucky, extremely lucky, when going to preview mode you will see two identical labels in one row. You may have to shift the left or right group. However, it is possible.

Now the more (easy and) flexible approach.
Start Word. Use Tools, mail merge. In step one choose labels. If you still have an empty sheet choose existing window, elsenew window.

In step 2 choose link data. Change the type to Access database, look for your database and next for the table or query [MyAdresses from above. There might be a small change that you can not link to Access. Add the appropriate converters to your office suite.]
Next you should set up your main document. Choose a label type, adapt or make a new one. I think this is more straightforward {give it an easy name for further use in other application with the same box of labels.] Once you have what you want a window for one label will appear.

Fill in all the fields, as you like; use again Enter and Spaces.
The advantage is that you can select a piece of text, right click with the mouse and change the format. So different letter types, bold, italics, points can be different in one label. After OK do not continue but close the mail-merge window. You will see something as the template [or mother sheet] for your labels. You will find out that if is actually a table. So you can afterwards always change all sizes like with a normal table [and also the format of (parts of) the text.]

by kees.valkenswaard

If you would press the new button with <> the same problem as in the previous approach: two different labels in one row. But do not worry. [Are you still there?]
Make certain that you see the field codes rather than the (preview) example. [Release the <> button.]

Remove all <> fields in the right column [not left!]. Make certain to select the complete field before deleting it. Check and you will see that you have what you want [two indentical labels in one row.] Save the mother sheet, you can use it every time again with the most recent data in your database.

The only thing you will have to do is to run the final step 3 of the mail merge. Do it always to a new document. [Too many trees went down for nothing.] It may sometimes look as if a label is partly at the bottom of a page. [Small shortcoming of Word. Do not worry, there are more like that. You may wish to check in the old normal view.]

Print a few pages on normal paper and check everything. Ok? Fine and ready to print.
If not, you may have to adapt the margins, the alignment within the table cells [just move the little rectangle left on the horizontal ruler or the little triangle at the extreme right. Before doing that select the full column [by clicking when the ugly thick down arrow is visible] You should do this with the mother sheet, not the result which may be a lot of pages consisting of tables.

by kees.valkenswaard

You can centre or align the text vertically within cells. You may notice by using the show/hide paragraph and other hidden characters, that there are two Returns [paragraph ends] at the end of each cell. Remove perhaps one [could be done with CTRL-H, replace ^p^p with ^p]

It can be necessary to lower the text in the top and to place the bottom text higher [because of the non-printable margins. Use vertical align in tables.]

Sometimes the master sheet consists of two pages. Move either thebottom line of the table or set the point size for the last paragraph sign at the far bottom to a very small point size, e.g. 1.

Of course you always can use a query in Word to limit the labels to be printed.

If you still have questions, mail me.
Good luck.

PS. I promised you a detailed reply. Both other answers basically are short descriptions of a possible, working solution. In my humble view we would have to share the points.

by mra2

Kees,
Great reply! With all of this help, mostly yours, I got it!!!!!

Thank you so very much, Alan

by bob sellman

Don't use Word unless you want to make life difficult. The solution is actually very easy in Access.

Change your label report format as follows:

1. Define the label setup as 1 across, 3 down.
2. For each "label" (one row on the report), repeat your current fields a second time so they will print on your labels where the second column of labels is located on the form. It would look something like this:

Name Name
Address Address
City/State/Zip City/State/Zip

The basic idea is that Access will work as if there are three labels per page, but since you have repeated the same name and address data on your label report, you will actually get six labels per page, but the second column will be a repeat of the first column.

by mra2

Bob,
The idea works! It took me over an hour playing with Page Setup settings including row setting BUT I GOT IT PERFECTLY!
Thanks so very much for your reply!

This discussion is closed to new replies.