Labels from tables

[Guest]

Access XP and Excel XP

I have a list of 700 students in 3 grades (9th, 10th and 11th) in an Excel
worksheet which I can import into an Access table.

With the students' names on each label, I want to create 8 labels for each
9th grader, 9 labels for each 10th grader, and 10 labels for each 11th
grader. I have label paper with 30 labels per page in 3 columns and 10 rows.
I want to populate the labels going DOWN not across. (I can do it in Word
going across.) This way, each 11th grader will get one column of labels.

Any ideas? I did it once but I don't remember how...

TIA

Guy

 

[Guest]

Hi Guy

I think you are going need a little code to make this work. You can get an
example of some code from here

http://support.microsoft.com/default.aspx?scid=kb;en-us;95806&Product=acc

Good luck

 

[Pete D.]

In word divide the columns into 3 separate columns or you can trick the
merge by rotating the text so it fills left to right from bottom to top. To
separated columns into 3 each just select the column and copy and past into
a new page. To get right quantities use the <<next record>> command. Your
data source still remains the access table.