2009-06-18

Use an UNC list for your internal emails

I just received a message from networking indicating my mailbox size was too large. This is largely due to mailing of large attachments. If much of your mailing is on an internal intranet anyway -- rather than clog up mailservers-- I recommend using these scripts to create 'UNC' lists for your emails.

Script Link:  !makeUNCList.au3

Script Link:  !makeUNCList.vbs.zip

If you drag~drop a list of files from a shared ~ network drive unto the compiled version of this script--they resolve to an 'UNC' list which you can paste into your emails. They then open like a hyper-link.

You'll need AutoIt to compile the script.

You'll need PrimalScript to compile the .vbs script.

Script Link:  !makeUNClist_add_ql.vbs

This script creates a Quick Launch item for a compiled version of !makeUNCList.au3 or !makeUNCList.vbs

In EXAMPLE1 -- I drag the ".vbs" file atop !makeunclist.exe -- resulting in my clipboard being set to the fully qualified file name. It also works with multiple files and on files open from a mapped network drive dragged to the quick launch shortcut in EXAMPLE2. EXAMPLE3 is how I use the UNC list in an email.

EXAMPLES:





Create Inserts from CSV via WebFocus and VBS

1. Create a simple webfocus report by dragging tablename to
output painter

2. Set output to 'COMT'

3. Run report

4. Drag resultant .CSV unto .VBS

5. Execute resultant .SQL



In this example I'm simply backing up a table. However, you could use the same concept to create a WebFocus report from multiple input sources and then if you name your output with 'tablename', and use the correct 'columnname' values for headings -- use to feed another system...



LibriVox's New Releases

Blog Archive