By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,948 Members | 1,857 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,948 IT Pros & Developers. It's quick & easy.

Multiple Mail Labels

P: n/a
I'd like to print mailing labels. Simple enough eh? In the db I just took
over, the previous fellow had some names listed multiple times, if those
folk got more than one copy of the our monthly newsletter. I'd like to clean
things up and have each name listed just once. Ideally, I'd have a column
for 'number of copies'. Then, when my label report ran, it would read this
number and print X number of labels. Is this possible? If so, can anyone
offer a suggestion about how to set it up code wise?
Thank you.
Becky
Nov 12 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Sun, 12 Nov 2006 08:13:12 -0800, "Rebecca Smith"
<re************@comcast.netwrote:

Of course there could be more than one "Jim Jones" in the world, but
if you have true duplicates in your table you need to start with
improving the database design. Put a unique index on the (combination
of) fields that makes a record unique. This will initially fail, so
you have some cleanup to do, but then it will work and will never fail
again.

Printing the "number of copies" like you indicate is a bit harder than
it may seem. Are you sure you need to go down that road. Cannot Jim
and Sally Jones share the same copy?
If not, I would probably pre-process the report by writing the records
I need to print to a "temporary" table using some VBA code with
recordsets. In this table the indexes are relaxed to allow
almost-dups. Then the label report would print from that table.

-Tom.

>I'd like to print mailing labels. Simple enough eh? In the db I just took
over, the previous fellow had some names listed multiple times, if those
folk got more than one copy of the our monthly newsletter. I'd like to clean
things up and have each name listed just once. Ideally, I'd have a column
for 'number of copies'. Then, when my label report ran, it would read this
number and print X number of labels. Is this possible? If so, can anyone
offer a suggestion about how to set it up code wise?
Thank you.
Becky
Nov 12 '06 #2

P: n/a
Create a new table with one column called say NumberOfCopies. If you need 4
copies of a label type 4 in 4 rows of this table.
If you need 6 copies of a label type 6 in 6 rows of this table.

In the table with the names, add a column called say NumberOfCopies and
enter 4 or 6 or however many labels you want for each name.

Then link these 2 tables together in a query and use the query to make the
labels.

"Rebecca Smith" <re************@comcast.netwrote in message
news:Wr******************************@comcast.com. ..
I'd like to print mailing labels. Simple enough eh? In the db I just took
over, the previous fellow had some names listed multiple times, if those
folk got more than one copy of the our monthly newsletter. I'd like to
clean things up and have each name listed just once. Ideally, I'd have a
column for 'number of copies'. Then, when my label report ran, it would
read this number and print X number of labels. Is this possible? If so,
can anyone offer a suggestion about how to set it up code wise?
Thank you.
Becky

Nov 13 '06 #3

P: n/a
Karl,
Intriguing
B.

"Karl" <so*****@sbcglobal.bizwrote in message
news:w7*******************@newssvr21.news.prodigy. com...
Create a new table with one column called say NumberOfCopies. If you need
4 copies of a label type 4 in 4 rows of this table.
If you need 6 copies of a label type 6 in 6 rows of this table.

In the table with the names, add a column called say NumberOfCopies and
enter 4 or 6 or however many labels you want for each name.

Then link these 2 tables together in a query and use the query to make the
labels.

"Rebecca Smith" <re************@comcast.netwrote in message
news:Wr******************************@comcast.com. ..
>I'd like to print mailing labels. Simple enough eh? In the db I just took
over, the previous fellow had some names listed multiple times, if those
folk got more than one copy of the our monthly newsletter. I'd like to
clean things up and have each name listed just once. Ideally, I'd have a
column for 'number of copies'. Then, when my label report ran, it would
read this number and print X number of labels. Is this possible? If so,
can anyone offer a suggestion about how to set it up code wise?
Thank you.
Becky


Nov 14 '06 #4

P: n/a
Karl,
Works like a champ - thanks!
B.

"Karl" <so*****@sbcglobal.bizwrote in message
news:w7*******************@newssvr21.news.prodigy. com...
Create a new table with one column called say NumberOfCopies. If you need
4 copies of a label type 4 in 4 rows of this table.
If you need 6 copies of a label type 6 in 6 rows of this table.

In the table with the names, add a column called say NumberOfCopies and
enter 4 or 6 or however many labels you want for each name.

Then link these 2 tables together in a query and use the query to make the
labels.

Nov 15 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.