Hello all,
I have a code that sends an excel sheet as an attachment to a specific email.
The problem comes with the fact that I have two accounts in Outlook and need to send the email from the one that is not the default.
I searched the web but did not find any solution. I read somewhere that there is no such code that can pick which email account should be used.
Is this true and is there another way to do that task?
You would need to automate Outlook and then set the SendUsingAccount property of the MailItem. I'm not an Outlook expert, but hopefully Googling that will get you somewhere, or you could try an Outlook forum, unless someone else jumps in here!
Remember what the dormouse said
Feed your head
That is my problem - SendUsingAccount property of the MailItem is available only with Outlook 2007 and I am using 2003
Told you I wasn't an expert!
You probably need the Logon method of the NameSpace - that allows you to specify an account and password.
DonkeyOte always refers to this url http://www.rondebruin.nl/sendmail.htm
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
see: http://www.devnewsgroups.net/group/m...opic56403.aspx
(considered using CDO ?)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
I do not want to use CDO.
I checked before the example from http://www.devnewsgroups.net/group/m...opic56403.aspx
But coud not make it to work. Where should I use the Function Set Account - in excel or in Outlook?
I think it would be something like this (requires a reference set to Outlook as written):
You would then need to create an email and do whatever you need to it.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks