Macros and passwords in SSH sessions

I'm experimenting with macros and scripting because it seems it should be able to make some of our processes more efficient, but I'm running into a hangup:

We login to a mercury environment and from there log into several different SSH connections to various servers. We typically have situations where we need to login to a box, run one or two commands, log out , then login to a different box and repeat. This often involves 15-20 servers or more.

I tried using a text macro, and it hangs on the entering the password on the first remote box. In the macro I have the password in plain text on the line right after the ssh line. When I run it, nothing happens at the password prompt.

Is there a way to have it run the password at the prompt and then move on to the rest of the commands? Ideally automatically logging out and logging into the next server and repeating until done?

Thanks for any assistance.

Brad