I was wondering how to determine which email account is used when sending a file from within an Office application.
The specifics are: I have an Excel spreadsheet that needs to be emailed to someone outside of the organisation at the end of every day. The person responsible for the data in the spreadsheet, makes the changes and then clicks on the ’email to’ icon on the toolbar. They select the recipient and then say send. My is that the email account used is not the same as the default email account set up in Outlook. In fact, in Outlook, there is only one account.
The details for the ‘phantom’ account are correct for a subsidary of the company and for a different location. eg the mail server says mail.subsidary.com.au instead of mail.mycompany.com.au.
So where would Excel be getting this information from?