A client called me today and asked for something that I'd not considered before - he had Excel spreadsheets that are connected to a data source, he wants to refresh them and email them out nightly
*** the email recipients are outside the domain and will not have a connection to the data souce
The article below describes how I did this