Email non-Excel file

[Guest]

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.

 

[Tom Ogilvy]

Check out Ron de Bruin's site

http://www.rondebruin.nl/sendmail.htm
http://www.rondebruin.nl/index.html

He has information on attaching files.

--
Regards,
Tom Ogilvy

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.

 

[Guest]

Thanks a lot Tom.

 

[Guest]

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.

 

[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

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.

 

[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)

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.

 

[Guest]

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

 

[plh]

I tried that CDO method to send grades around to a class I teach, but
I got back "delay" then "failure" messages. It took several days, but
they came around. Any suggestions? Perhaps anti-spam programs block
mail generated by these sorts of processes?
Thank You,
-plh

Check out Ron de Bruin's site

http://www.rondebruin.nl/sendmail.htm
http://www.rondebruin.nl/index.html

He has information on attaching files.

I keep hitting "Esc" -- but I'm still here!
[if "123" is in email address, that is an anti-spam thing.]