How to create mailing labels

[dbdinc]

Has anyone out there ever tried creating mailing labels from a stored process? If so, would you share your discoveries? I think the hardest part is going to be columnizing the printed output.

Thank you.

 

[dbdinc]

Disregard this posting. I figured it out.

 

[ChrisW75]

Hi DBDINC,
What method did you use in the end? The standard process I would guess would be to use a data _null_ step and put statements to write the data out...

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.

 

[dbdinc]

Hi, Chris,

One method I found is located in the SAS website, under samples. Here is its link:

http://support.sas.com/ctx/samples/index.jsp?sid=848&tab=output

Another method came from a white paper from SUG31, and here is its link:

http://www2.sas.com/proceedings/sugi31/149-31.pdf

Sorry I don't know how to properly stick a link into my reply.....you'll have to copy and past the URL's into your Explorer window. Also, how do you use a data _null_ step and put the statements to write out? I'm quite new to SAS and would love to learn more things, such as the _null_ step things.

Let me know if you have any comments or questions.

 

[klaz2002]

You could use DDE and then have MS Word (with an Avery template) format the labels for you. I don't have the time to right the code but I can quickly lay it out.

You need to look up DDE triplet lingo. Find the one for launching MS Word. Then use the Ms Word Basic Script commands in a Data _null_ step to dump the label data to the Avery Template. Then have word either save or print the result. I usually close the word doc as well after I finish. Lookup word basic for the proper commands. I use this method to populate a word doc (I use the bookmarks) with data and then I send it to the printer.

sorry if this sounds crazy and with no code it sure is hard to try, but I find some time soon I will try to write this up.
Klaz

 

[dbdinc]

Hi, Klaz....

If you could write out some code as an example to do that, I'd love to see it.

Thanks!