DatabaseRobert
Level 4

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....

0 Cheers
Reply