Merging emails from Access (2003)

Topic

New Reply

Hi

I am writing Access code to send multiple emails from a query in an Access database. I’m going to use the CreateItem method in VBA and am reasonably clear how to code this.

The problem is that at work my Outlook has several different accounts (for different related companies) and I want to be able to send the emails from a specific account (not the default). Is there code that can tell Outlook to create the emails using a nominated account, similar to my selecting the account through the accounts button on the toolbar?

Many thanks

David

Reply | Quote

Replies

I don’t recall a clean way to do this. My past “solutions” have involved code to manipulate the Accounts toolbar button. This won’t work very well if you don’t have an Inspector window open on the screen…

Reply | Quote