Hi All,
I am trying to send an email from Excel. I was using the CDO commands but that's not working on the new computer, so I'm trying to use Outlook. The issue I run into is I have to use several different accounts to send emails. All the accounts are corporate Exchange accounts, so I was going to create a new profile for each account in Outlook. In Excel VBA, how do I create a new message using a specific profile/account?
I'm also open to other suggestions. I tried looking into creating all the accounts within 1 profile and using POP3 as the settings for all but 1 account, but I don't have the POP3 info yet to test.
Thanks!
I am trying to send an email from Excel. I was using the CDO commands but that's not working on the new computer, so I'm trying to use Outlook. The issue I run into is I have to use several different accounts to send emails. All the accounts are corporate Exchange accounts, so I was going to create a new profile for each account in Outlook. In Excel VBA, how do I create a new message using a specific profile/account?
I'm also open to other suggestions. I tried looking into creating all the accounts within 1 profile and using POP3 as the settings for all but 1 account, but I don't have the POP3 info yet to test.
Thanks!