Since I was in the same position as you and just tried MP for the first time tonight, I thought I'd respond.
I had to create a new gamespy ID through Civ4. My existing ID did not work and I don't know why. But that's pretty straightforward - multiplayer, new, put in a bit of info, done...