Email non-Excel file

F

Francis Ang

Can anyone out there help me? How I do I write the code to email a non-Excel file say a .txt file? I have browsed through the help function but it only discussed on emailing Excel worksheets.
 
F

Francis Ang

Tom, Can you help me again. I have tried the codes it works OK but how do I change the default mailer to Outlook Express? The default is currently Microsoft Outlook.
 
T

Tom Ogilvy

I don't believe you can do this with outlook express - outlook express does
not support OLE Automation which I believe is what Ron is using. However,
there is a lot of code on his site, so I don't know specifically which code
you are using. If you are using some of his CDO based code, then it may not
be an issue with the OLE Automation part.

In outlook express, under tools=>Options, in the general tab, there is a
button at the bottom that says make default if it isn't the default. If
you want to know how to do it in code, I suspect it is a registry entry, but
I don't know which one it is. Perhaps a gooble search.

--
Regards,
Tom Ogilvy

Francis Ang said:
Tom, Can you help me again. I have tried the codes it works OK but how do
Click to expand...
I change the default mailer to Outlook Express? The default is currently
Microsoft Outlook.
 
R

Ron de Bruin

Hi Francis

Excel use the program on the Control Panel>Internet options (Program Tab)
Change this to OE

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




Francis Ang said:
Tom, Can you help me again. I have tried the codes it works OK but how do I change the default mailer to Outlook Express? The
Click to expand...
default is currently Microsoft Outlook.
 
F

Francis Ang

Thanks a lot Tom, Ron. Now it works perfectly. Your all are wonderful people.
 
Top