If the table is a standard, comma or space separated value, like this:<div>filename, email<br>filename, email<br>filename, email<br><br>or something else consistent.</div><div><br></div><div>You can use a scripting tool called Awk to separate the contents, and pipe the output to another program.</div>
<div>Unfortunately, I don't know if there's a program to email from the terminal (I'm assuming there is)</div><div><br></div><div>But the English-pseudocode would be like this:<br>Awk: "For every line, take the 'first bit', then take the 'second bit' "<br>
Awk: "Hey, email program. Please attach 'first bit' to an email and send it to 'second bit'"<br><br>If you send a small example of how the table is layed out, I could probably help you a lot better!<br>
<br><br><div class="gmail_quote">On 3 June 2010 10:36, m1eai <span dir="ltr"><<a href="mailto:m1eai@mac.com">m1eai@mac.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div><div>Hi people,</div><div><br></div><div>Quick question to see if anyone has encountered this problem before. I have a directory of spreadsheets produced by are accounts system and the accounts department want to automaticly send out these emails to a list of people. Each of the spreadsheets has a unique and consistent name so has anyone seen a program that can read a file name, look it up in a table and email that file someone in a look up table. Or is there a simple way to do it with scripts.</div>
<div><span style="white-space:pre"><br></span></div><div><span style="white-space:pre">Andy Beale</span></div></div>
<br>_______________________________________________<br></blockquote></div><br clear="all"><br>-- <br>R. James Holland<br>0115 9 509 789<br>
</div>