Hey John,
Open the Keychain Access.app.
Get-Info on the password you want to use.
Use the Name and Account specified in the Get-Info panel.
When you first run your macro you'll be asked to permit Keyboard Maestro to use the KeyChain for that item.
-Chris