Hi netzig

You can use CDO if it is possible for you?
http://www.rondebruin.nl/cdo.htm


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"netzig" wrote in message ...
I have read through all of the searches that concern emailing from Excel and I know it is possible to email workbooks from VBA
code if you use Outlook as your mail client. However in my case we do not use outlook and I have been unable to find any
solution to this problem. We use mostly Pegasus mail and a couple people use Eudora. I am sure that there has got to be a way to
make it work. Any help would be greatly appreciated.

Hi

What example you try??
If you comment out the AddAttachment line is it working then???

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"netzig" wrote in message ...
Thank you, it does work for me, however for some reason I cannot use the .AddAttachment, it keeps telling me that the
argument is not optional when I try to compile it. Any ideas?

----- Ron de Bruin wrote: -----

Hi netzig

You can use CDO if it is possible for you?
http://www.rondebruin.nl/cdo.htm


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"netzig" wrote in message
...
I have read through all of the searches that concern emailing from Excel and I know it is possible to email workbooks
from VBA
code if you use Outlook as your mail client. However in my case we do not use outlook and I have been unable to find any
solution to this problem. We use mostly Pegasus mail and a couple people use Eudora. I am sure that there has got to be a
way to
make it work. Any help would be greatly appreciated.

Nevermind, I figured it out. I am supposed to have that line as follows, fyi for anyone who cares

..addattachment ("filepath and name here"

Thanks again for your help

You are welcome

You can see it in this line also that is in every example
' You can add any file you want with this line .AddAttachment "C:/Test.txt"


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"netzig" wrote in message ...
Nevermind, I figured it out. I am supposed to have that line as follows, fyi for anyone who cares:

.addattachment ("filepath and name here")

Thanks again for your help

Yea, I must have read that line 5000 times before figuring it out on the 5001st time. But I do have one question, what would be the advantages of using one instead of the other? Is is just the fact that using the the first one (where you have to fill in the smtp server) you dont have to set any references?

----- Ron de Bruin wrote: -----


You are welcome

You can see it in this line also that is in every example
' You can add any file you want with this line .AddAttachment "C:/Test.txt"


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"netzig" wrote in message ...
Nevermind, I figured it out. I am supposed to have that line as follows, fyi for anyone who cares:
.addattachment ("filepath and name here")
Thanks again for your help

If you must fill in the SMTP server line the examples in the problem section there are indeed two examples
Late Binding and Early binding

Early binding is a bit faster but you must set a reference and most people have a problem with that.
And the Intellisense showing you the properties and methods of the objects as you type them


See Dicks page about binding for Outlook.
http://www.dicks-clicks.com/excel/olBinding.htm



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"netzig" wrote in message ...
Yea, I must have read that line 5000 times before figuring it out on the 5001st time. But I do have one question, what would
be the advantages of using one instead of the other? Is is just the fact that using the the first one (where you have to fill in
the smtp server) you dont have to set any references?

----- Ron de Bruin wrote: -----


You are welcome

You can see it in this line also that is in every example
' You can add any file you want with this line .AddAttachment "C:/Test.txt"


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"netzig" wrote in message
...
Nevermind, I figured it out. I am supposed to have that line as follows, fyi for anyone who cares:
.addattachment ("filepath and name here")
Thanks again for your help