Full Page Address Labels

[orange]

Can you remove confidential/personnel info from your database and post a copy in mdb format


( with enough records to see what you have)

[ealexander]

Oh dang... I'm off work now. I will try to post tomorrow. Thank you for your help!! I appreciate it so much!

[orange]

Oh dang... I'm off work now. I will try to post tomorrow. Thank you for your help!! I appreciate it so much!

I think I may have misinterpreted you requirement. I thought you were wanting 30 labels for each person???

But as I read the posts, I think the issue is that RG has Ac2010, you have Ac2007 and I have Ac2003. I was going to help with some code to do a 30 iteration loop, but I don't think that is relevant.

My guess with what you have to do is - if about 30 3 up labels fit on a page, (3 across by 10 labels down = 30 per page),

then as RG said follow the Label wizard for your label type and 3 up. Run a test page, if your spacing is off, then adjust the margin, or vertical spacing between labels such that you get your quantity per page.

As I said I don't use labels, so I found this tutorial http://www.youtube.com/watch?v=vvzAXgTTVP4 that should give the basics.

Let us know how you are doing.

[ealexander]

good morning! Yes, I do want 30 labels for each person (a full sheet). So having the loop is great. I will watch your youtube video here shortly. Thank you for all your help.

[orange]

I do have a solution. I took the Northwind Customers and selected the fields required for labels (my guess). Then created a new table with the same fields. Then created small routine to create 30 records for each person in the original.

Set up the Label wizard for 3-up; adjusted the spacing for 10 rows per page.

Seems to work.

Have to go out for about an hour. Post if you need any of this stuff (I have it in ac2003).

Decided to post the mdb

see this Procedure in the mdb
'---------------------------------------------------------------------------------------
' Procedure : Create30RecsPerPerson
' Author : Jack
' Date : 29-08-2012
' Purpose : To create a table with 30 copies of each persons record.
'This is a method to prepare for printing 30 3-up labels per person.
'
'This will create the new Table and populate it with the 30 records per person.
' The new table will be the source data for the Label wizard.

[ealexander]

Thanks to everyone! I finally got it. I appreciate all your help. I spent about 3 days on this.

[orange]

Glad you got it working.