Hi Ron,

I have been using your codes for years, they are fabulous. Thank you very
much.

Until last month when I change to a new company using Microsoft Exchange
Server. I cannot send anymore Excel with attachment by CDO. I had gone
through your website just want to confirm again that CDO doesn't support
Exchange Server (and only smtp)? that means I have to use click-it at
outlook? But I got hundreds of email to send everyday.

An option is use gmail, and I did. But the sender becomes "Angus
]". It looks odd as I am sending very serious
emails. Is it possible to make it appears like "Angus Casey
]" even I send it via smtp.gmail.com?

Angus

"Ron de Bruin" wrote:

Or use CDO
http://www.rondebruin.nl/cdo.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JLGWhiz" wrote in message ...
This from Excel help files.

To send e-mail from Excel To send data as an attachment, you need
Microsoft Outlook, Microsoft Outlook Express, Microsoft Exchange Client, or
another 32-bit e-mail program compatible with the Messaging Application
Programming Interface (MAPI). Make sure Mapi32.dll is in the Windows System
folder. To send Excel data as the body of a message, you need Outlook 2000 or
later.



"x taol" wrote:

I have outlook application.
How can I know what sending mail without outlook?

*** Sent via Developersdex http://www.developersdex.com ***