On 16 April 2004, 13:05, Terry wrote: > Just checking - have you set TB! as the default MAPI handler?
>> So is it possible to use OLE Automation / ActiveX to "drive" TB in >> this way? If so, do I need to upgrade to 2.x to get that >> functionality? > You don't need 2.x for this. Utilize a DoCmd.SendObject. Since TB! is > default, it should work with no need to create a session. I've done it > in Access using VBA with TB! version 1.62 and up. If you want to see > the code, I'll be happy to send it to you. (I'm on digest so sending > me mail privately would probably be quicker.) I wrote it for a series > of work reports that needed to go to different managers where some > received only some of the reports. Anyway, it loops through a table > and sends the necessary reports. Don't know if it would make sense, > but you're welcome to it. ~~~ Hi Terry, and thanks. Yes, I have TB as the default MAPI handler. >From looking at the Help, I suspect that DoCmd.SendObject won't do what I need for two reasons: - I need to send a text message, not a report, table, query, etc. That is, the material I need to send is not an Access object. - I need to post a copy of the message into the sending account's Sent Mail folder. That said, I'd be grateful of the code samples for future reference. FWIW, I'm also considering creating text files with .msg extensions (that is, constructing the messages from first principle so that I can import them into my Outbox ready to send). If I can't get the MAPI thing solved, that may be my best option. Thanks again, -- Geoff Lane Cornwall, UK -- Using The Bat! v1.62i on Windows XP 5.1 Build 2600 Service Pack 1 Word Happens ________________________________________________________ http://www.silverstones.com/thebat/TBUDLInfo.html
