No, he was not ambassador; he was not confirmed by the Senate. Senator Helms blocked a vote on the nomination.
Really! I was living in MA at the time, and I don’t remember him being rejected. Probably wrote him off for even attempting to work for WJC.