I am guessing SSIS is the way to go, but FYI I've previously done this by setting up the Excel file as a LINKED SERVER and then immediately dropping it:...
The message editor is puking because i am inserting html tags into the @body below. I've had to remove it to show the format i'm using. I'm just inserting a...