I have 2 email accounts configured in my outlook 2007 and sometimes I would need to use the 2nd account to send emails. If I open a new message, click on the "account" button and choose to send from the 2nd account manually, it works fine.

However, when I try to set .SendUsingAccount in an excel macro to send the emails via the 2nd account, it failed. I received an Undeliverable error msg sent by outlook saying "You cant send a message on behalf of this user unless you have permission to do so."

How can I solve the problem?