Creating Avery Labels to be printed from the web?

[Ovatvvon]

Question:
How can you create a page to be able to print a users name and address to a standard Avery label sheet (3x10 - 1" x 2&5/8" - Standard "5260 Address" labels)?


Problem:
I have a site that will list a users name and address when a person searchs for that user in the database. It will display the name and address on the web page. How can I create a link on that page to allow the person to print off a sheet of labels useing the listed users name and address...hopeing for a single click deal...just click on the link or button, and starts printing off the labels.

Thank you for your help in advance!!
-Ovatvvon

(I owe a big favor to whomever informs me of this!)

 

[Ovatvvon]

Can no one help with this? I really need to know this info badly, can't seem to find it...but I know there's a lot of people much more knowledgable and much better at finding info than I am.

Please help...
-Ovatvvon

 

[snix1]

Is there an answer to this one? It seems I may have to do the same thing. We have a Microsoft SQL Database. The client wants to do a query and then print the results out as mailing labels. Is there another product I can use to do this? I'm looking for the answer.

Thank you.

 

[ahmun]

This is something I am looking into, too. But to throw an answer to your problem, try the following:

I have developed a dynamic phone list for my company based on an IIS component called ABCpdf from

http://websupergoo.com/

I'd have to say the ASP pages I developed are an awesome piece of code. It takes all the employee's info from a database, and generates a PDF phone list based on the users' selection, a seperate up-to-date dynamically generaetd PDF for each region of the company. I then developed a set of web pages for a few key admin people to maintain the content of the phone list.

You could try doing a similar thing with your mailing labels. Here are some tools might need:
[ul][li]IIS or some kind of web server[/li]
[li]A Copy of ABCpdf from websupergoo (the cost is relatively cheap)[/li]
[li]ASP coding experience[/li][/ul]

Using VBScript/ASP, you can use the ABCpdf component to dynamically generate a label page, or multiple pages. To layout the page properly, you would need to use the exact measurements that Avery publishes for their labels, and code your program accordingly.

My request to all you wonderful Tek-Tip Gurus out there is: I would like to find a canned server-side label-generating solution. I don't have enough time to dedicate to developing this, since there is enough interest to warrant me finding a solution, but not enough interest to justify my time.

Or... if anybody wants to join me, help me create a component or open source Code that can do this, to share with the community, I could noodle with some code on my spare time...

Earnie Eng

 

[Genimuse]

It's a reasonably trivial task to lay out labels using point-specific placement of elements via CSS, I'd think. It all comes together instantly in my head, anyway, but I haven't time to contribute to any non-paying projects right now, unfortunately.

 

[Tarwn]

You could probably also set it up so that most of the content has the display: none; set for print media, basically define two style sheets (one for screen, one for print)...or better yet just have them click on something and then uss absolute position (per Genimuse's comment) to make sure thy are all spaced out right. You could even let the user input the labe sizes on the previous page and calculate where the top left corner of each label is...

-T