Try adding "localhost" to CreateObject like this:

Set OutApp = CreateObject ("Outlook.Application", "localhost")



"Ron de Bruin" wrote:

Good morning

Try this first
http://www.rondebruin.nl/mail/problems.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"David" wrote in message ...
Yes...Outlook is installed. Outlook 2003. I'm not sure what you mean by set
the reference in the VBA, but I am using your complete code. It works on all
other locations except this one. Thanks for answering...I just can't figure
this one out.

David

"Ron de Bruin" wrote:

Hi David

Is Outlook installed on this machine ?
And have you set the reference in the VBA

--
Regards Ron de Bruin
http://www.rondebruin.nl


"David" wrote in message ...
Hi Ron,
I've been using your code without a hitch to create an email, attach a file
and send it off. I am having a problem with one user though, and am getting a
run-time error '-2147024770 (8007007e)' Automation Error The specified module
could not be found.
Have you run into this before? The code is stopping at this line:
Set OutApp = CreateObject ("Outlook.Application")

Thanks!
David

"Ron de Bruin" wrote:

See this site

Sending mail from Lotus Notes (XL-Dennis)

http://www.excelkb.com/?cNode=1X5M7A


--
Regards Ron de Bruin
http://www.rondebruin.nl


"John" wrote in message ...
Does anyone know how to send an Excel Workbook as an attachment in a email
from a button on the Excel workbook. We use Lotus notes as our email so if
anyone has done something like this and can point me in the right direction I
would greatly appreciate it. If there is anyway to save the email in the
person's mailbox that would be the topping on the cake also.

Thanks in advance,
John