On 06 February 2003, 10:42, Nick Dutton wrote: > Can anyone tell me how to make this work please? ~~~
FWIW, I tried the following in the Immediate window of Excel 2000: ActiveWorkbook.SendMail Recipients:="<email>", Subject:="Test Message" and it worked without problems. However, your comment that it works when Outlook is selected as the default mail client but not when TB is selected gives me a clue. Outlook and TB require different versions of the MAPI DLL to act as default simple MAPI handler and I suspect that, while you switched default client, you did not configure TB as the default simple MAPI handler. Outlook is brain dead and can't (IME) act as simple MAPI handler unless it is also the default mail client -- so simple MAPI has no valid handler on your system. Caveat: setting TB as your default MAPI handler may render Outlook unserviceable. To set TB as your simple MAPI Handler: 1. From the Options menu, choose Preferences. 2. Click the Applications tab. 3. Click "Install The Bat! as the simple MAPI request hander" HTH, -- Geoff Lane Cornwall, UK -- Using The Bat! v1.62i on Windows XP 5.1 Build 2600 Service Pack 1 Word Happens ________________________________________________ Current version is 1.62 | "Using TBUDL" information: http://www.silverstones.com/thebat/TBUDLInfo.html
