
Outlook/MAPI/CDO is making me crazy.
Greetings,
I'm having big problems with Outlook/MAPI/CDO, and am in dire need of
assistance.
I want to:
1. Login to MailboxOne
2. Send e-mail based on data in an Access table
3. Logout of MailboxOne
4. Login to MailboxTwo
5. Send e-mail based on data in an Access table
6. Logout of MailboxTwo
7. Repeat for as many mailboxes as needed (held, most likely, in an Access
table).
All of this needs to be without human intervention (entering passwords and
such).
I have tried automating Outlook, but each mailbox has a different password,
and each of those is different than the user's network password, so setting
Outlook's authentication to NT Authentication doesn't prevent the login
dialog box (username, domain, password) from popping up.
I have tried using CDO to simply send all the messages from a single
mailbox, but changing the .Sender property so they appear to originate from
the correct person; I get messages that I don't have permission to send on
behalf of So-And-So, even though I have set myself to have permission.
*Any* assistance (books, websites, etc.) would be appreciated.
Regards,
Dave Glass