SMRT! It’s working!

I am so SMRT!

smrt.jpg

OpenNTF.org – Print attachments with OLE Automation

I can’t believe it, I got a Lotusscript working that prints file attachments from selected emails! It almost worked “out of the box” from this website, but the comments included additional clues, and I ended up registering so that I could ask a couple of specific questions.

In the meantime, I learned a tiny bit about how to load a Lotuscript – and even how to remove whitespace so that it’s properly formed (not difficult, as Lotus has highlighting all set up so you know when you’ve gone wrong). I tried a couple of copied-and-pasted methods, but this one was clean, and with the addition of the agent from the comments below it into the “Initialize” section, it worked – although it printed all the worksheet tabs, resulting in multiple sheets. I only needed it to print just the first sheet – but that question was quickly answered in the comments, and now all I have to do to print these is select a bunch of the incoming emails and hit an action menu item. I can’t seem to get it working automatically on incoming mails, but maybe it’s better to have a little more control so that I know that the printer is working… my printer is a trashed one that doesn’t have a working error code display for “Load Paper.”

This solves a really tedious problem we’ve been struggling with at work – basically, from one department at our major client, we receive all reservations as file attachments that can be TIF, PDF or MSExcel formats. We have Lotus Notes, and printing file attachments is normally done one email at a time, and there’s a lot of mouse-clicking. On Mondays and Tuesdays, when we receive 30-70 emails per day, that’s a lot of time spent opening, clicking, printing, closing, opening, clicking printing, closing. My supervisor has been doing this to free me or one of the other agents up for more important work taking calls or working on groups. It was a ridiculous use of her time.

The bit that I had to modify in order to just print the first sheet was in the Excel subroutine:

Private Sub PrintMSExcel (fname As String)Dim app As Variant  

Dim docToPrint As Variant  

On Error 208 Goto err208  

Set app = createobject("Excel.application")  

Set docToPrint = app.workbooks.open(fname)  

' No background print option for Excel, no need for special handling.
' Change (1,1) to () to print all worksheets  

Call docToPrint.PrintOut(1,1)

  

Call app.workbooks.close  

Call app.Quit()  

Set app = Nothing  

Exit Sub

It’s all good now, though. Monday, we’ll be ready for the onslaught. I even added a commented-out note to change the one setting to print all sheets if that’s what’s needed.

Quiver Full of Bull

Salt Lake Tribune – Full quivers don’t pay

The opinion by David M. Pearson (Forum, June 9, “Subsidizing children”) is the most illogical and self-serving analysis I’ve seen in a long time.

He wrote that he is helping to subsidize people with few or no children. Since he has nine arrows in his quiver, he gets enormous tax deductions for his progeny. This means he pays little, if any, taxes compared to a single person, or those with few or no children. How he can figure that he is “subsidizing” anyone is a real fantasy.
As a consumer of governmental services, he is not subsidizing anyone, but consuming far more than he contributes. His children will not contribute to my Social Security, they will consume their own Social Security payments. Also, if his quiver of nine bundles of joy also have nine arrows in their quivers, they too will be consumers of governmental services and not pay taxes either.

I hope that the Pearsons do not try to continue “helping” subsidize anyone. They should find another hobby. Their current one is not helping. If their way of doing things were correct, India, China, Africa and South America would be the most prosperous and least crowded countries on Earth.

 Bill Revene

Salt Lake City

It’s always been my understanding that a larger percentage of our household tax dollars go to subsidize public education, compared to families with large numbers of children (thus, more tax deductions). I’m happy to pay taxes for education, because an educated populace is a free and independent populace, and an informed electorate.

At least, that’s the theory.  A few years back when I was much more radical about these things, I used to grouse a lot more loudly about small vs. large footprints, overpopulation, and the fact that poor people without children often had less access to health care and benefits, because poor people with children qualified for many programs not open to single or married couples without children. I had mostly forgotten how outraged I used to be at the thought, and then I watched “Rain in a Dry Land” last night, about two Somali families who were relocated to the U.S.

At one point, the parents of a very large, poor family (9 children – it’s a miracle they all survived the civil wars) were offered a choice: the mother, whose youngest child recently turned two, either had to get a job or go to school. There was no money for child care, and the oldest daughters were doing too well in high school to curtail their education, which was something. “Or….” the social worker offered “if she were to become pregnant, then there would be a medical condition exemption, and also one for having an infant or young toddler…”

The Somali translator took this in, turned to the parents, and said “Have you considered having more children?” Their faces lit up.  Of course, the perfect solution, and the mother looked relieved, hopeful, and apprehensive all at once. If Allah willed it, she would welcome another child, or not, whatever happened.

Less than a year later when the documentarians returned, there was a new baby American in the household. I couldn’t decide if I was moved, or annoyed. I was mostly happy for the family, because the father had found work that was relatively fulfulling (landscape and carpentry work) and everyone else seemed on an upward curve except perhaps for one of the older sons, whose grades weren’t good enough to get him a soccer scholarship to college.

In the other family, at least one of the daughters was likely to wind up pregnant and unmarried not long after the end of the film, but her mother was trying to head that off. Good luck to her. By the way – the Somali people, or at least the Bantu as represented by the families in the documentary are incredibly beautiful, with gorgeous cheekbones and smiles.
Getting back to the letter to the editor:  that’s tellin’ ’em, Bill! But I doubt anyone will see it from your point of view. I do, but then I don’t live in Utah anymore for a very good reason – the smug complacency of the religous quiver-fillers.

YouTube – Writing for SystemiNetwork.com

YouTube – Writing for SystemiNetwork.com

What “working from home” REALLY means when you’re an RPG programmer, it’s after 10, and you’ve drunk a little too much coffee.

[kml_flashembed movie="http://youtube.com/v/czWvC2xRnRo" width="400" height="326" wmode="transparent" /]

My husband David knows this guy, who’s on many of the mailing lists David hosts on midrange.com. In fact, they were almost roomies at the most recent COMMON meeting.

David almost came home a headbanger – that would have been interesting!

Baby Stroger Kept Cancer Secret For Election

What do voters need to know? | Chicago Tribune

Cook County Board President Todd Stroger, who zealously guarded details of his father’s crippling stroke last year, kept his own cancer diagnosis secret as he campaigned to succeed him, his administration acknowledged Tuesday.Todd Stroger, who learned about 10 months ago that he had an early stage of prostate cancer, had his prostate gland removed Monday at Northwestern Memorial Hospital, county spokeswoman Ibis Antongiorgi said. “The doctor expects a full and speedy recovery,” she said.

More B.S. from the Stroger political clan, and of course as I thought, he didn’t have the procedure done at Stroger Hospital, the public health care facility named for his father. Because of the budget cuts and all.

Also as I thought, his health problem was pretty darn personal, but he’s still going to catch a lot of heat for keeping it secret from even his own campaign staff (actually, his father’s campaign staff, who were also keeping Daddy Stroger’s post-stroke status under wraps).

Peraica, who was the Republican candidate, was a bit of an ass on Election Night, and dependably offers a tart quote that stops short of saying “if only the voters had known.”

[tags]Chicago, Stroger[/tags]

Village Idiocy

Flickr

Via: Flickr Title: 06-19-07_1942.jpg By: GinnyRED57
Originally uploaded: 19 Jun ’07, 7.43pm CDT PST

The Village, its wisdom, decided to repave all the streets in our subdivision this summer, and the notification letter was received Wednesday, when we went out of town. Although they’d previously announced we’d have more notice, they actually gave only 2 days’ warning before taking off the first layer of asphalt, on Friday. We returned Sunday night from our trip to find that the street was blocked off to thru traffic, but somewhat driveable.

Good thing we moved the cars this morning before we left, they started tearing things up right around 9am but blocked our driveway well before that time.

Tonight when I returned, I found a place to park around the corner, and came out front to see what was up. The street is a churned morass of ruts and hardened clay mud.

Meanwhile, David’s got a webcam trained on the street – you can see it here.