I think geeking ADDS to sociability, aka tech help

[jack]

Suppose I had a spreadsheet with columns name, email, and message, and I have a windows computer and an account on a unix server. What do you think the easiest way to turn that into n emails is?

Comments

[cartesiandaemon.livejournal.com]

I'm required to have the windows computer running for my job, but otherwise ok :)

[satanicsocks.livejournal.com]

Skin it to look like a Mac. Excel can export to CSV though.

[filecoreinuse.livejournal.com]

And probably do the mailing via some sick VBA thing. Although is any sensible admin finds a Windows machine sending lots of email via MAPI Jack might find his machine off the network fairly quickly.

[cartesiandaemon.livejournal.com]

Well, not *lots*. VBA probably can do it, actually, but for some reason I'm leery of trusting it :)

[satanicsocks.livejournal.com]

Actually, I wrote a VBA thing to do exactly that many years ago. Oh for hindsight!

[cartesiandaemon.livejournal.com]

Yeah, it probably is one of the standard examples. But it will require me configuring outlook.

[mobbsy.livejournal.com]

If you need to do this more than once, you could look at the OOo scripting to automate the .xls -> CSV conversion:
http://udk.openoffice.org/python/python-bridge.html
Some examples or a mostly integrated package that looks like it requires minimal extra scripting.

(All from googling, rather than experience).

[cartesiandaemon.livejournal.com]

Probably rarely enough that that wouldn't really be a bottleneck. I think. THanks.