Changing Outlook Account Used

[Ethan]

Hello,

I currently use Access 2002 to create a batch of emails
each night. The emails are all being sent from the
default email acocunt.

I need to have the emails sent from the various email
accounts set up in Outlook.

I was able to get the From email address to read a
different email, in my outbox, using the
objOutlookMsg.SentOnBehalfOfName code. However, once sent
the emails show the From address as the default email
account.

I also tried to change the profile with the following code
from the automation help file:

Set olookApp = CreateObject("Outlook.Application")
Set olookSpace = olookApp.GetNamespace("MAPI")
olookSpace.Logon ProfileName

' use the Display method to actually show the Outlook
' session and view the Inbox folder.
olookSpace.GetDefaultFolder(olFolderInbox).Display>

Still no luck. Any help would be appreciated.

Thanks
Ethan

 

[Cheryl Fischer]

AFAIK, that capability is not available in Outlook Automation. I use the
ACG Soft PDF and Mail Class Library to set the account from which my
programs send emails:

http://ourworld.compuserve.com/homepages/attac-cg/acgsoft.htm

Another excellent add-in is Redemption:

http://www.dimastr.com/redemption/