- Mark as New
- Permalink
- Report Inappropriate Content
Normally I don't like replying to myself, but it came to me that others may have a use for something we do here.
We have several DYMO label printers scattered around the office. These are just thermal printers, but they're great for "one-off" labels that you don't need a whole sheet of. (Like for "that ONE client who lives in Alaska"... what do you need a whole sheet of Alaska DoR labels for?) Or sending mail to the client: I just need one, not a 3x10 sheet of Avery labels to the same client.
However, we also used them--in the days before the ODBC connection, just with a straight read of the DBF file--to pull out partners/beneficiary information. We never bothered with Slip Sheets (use a whole sheet of paper, which adds up and may change the postal rate), just print off a quick label.
But if you reach out to Data2, where the partners/officers/estate beneficiaries are stored, and grab their name [keep as one column], street [keep as one column], apartment [keep as one column], and city/state/zip [combine into one column, add ", " and " " so you get "Cityname, ST ZIPCODE"]...
...then you get a multi-row list of multiple columns.
Which the DYMO software interprets a "Ctrl+V/paste" of as, "You have 6 labels here! Do you want me to print (with each row being a new label, eacn column being a new line on the label)?"
Presto! Roll a half-dozen labels, slap them on the K-1 envelopes being given to the primary signer, and they just need to put on their return address (label) and postage.
Now, if I could just convince the estimates to store their "send to" address in a convenient spot....