In time I evetually handled this by creating a different user. One for work and one for home. I added things I need for both accounts (iTunes library, iPhoto library, etc...) to the Shared users folder.Then I was able to add the Automator application I created in the Login Items for it's respective account. This kept my work and home stuff separate aside from a few shared items in the shared user folder.
But here is what I initailly did:
Open AppleScript Editor (/Applications/Utilities) > New Document.
Copy and past the script below:
set allLocations to {"In Office", "Out of Office"}
set mainlist to the button returned of (display dialog "Choose a Location" buttons allLocations default button "Out of Office")
if (text of mainlist) = "In Office" then
tell application "Automator1" to activate
end if
if (text of mainlist) = "Out of Office" then
tell application "Automator2" to activate
end if
Where Automator1 is the Automator application you created to connect to your work drives and Automator2 is the Automator2 application you created to connect to your home drives.
If you want you can also change the button that is highlighted by default (default button). I had mine set as "Out of Office".
Obviously if you choose you can also change both "in Office" & "Out of Office" to something more suitable to you.
When you are finished: File > Export > name it, select a location to save it (I suggest your Applications folder) and then select Application as the File Format and Save. You can then add this to your Login Items.
This will give you a popup menu when you log in asking if you are "In Office" or "Out of Office". Select one and it will run the appropriate automator application you created.
