| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email non-Excel file
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.
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Email non-Excel file
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 "Francis Ang" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Email non-Excel file
Thanks a lot Tom.
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Email non-Excel file
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.
|
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Email non-Excel file
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" wrote in message ... 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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Email non-Excel file
Hi Francis
Excel use the program on the Control PanelInternet options (Program Tab) Change this to OE -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "Francis Ang" wrote in message ... 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. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Email non-Excel file
Thanks a lot Tom, Ron. Now it works perfectly. Your all are wonderful people.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return excel file by email | New Users to Excel | |||
| convert email address file in Excel 2000 to Word file with commas | Excel Discussion (Misc queries) | |||
| Email excel file help | Excel Discussion (Misc queries) | |||
| how do I email an excel file in Novel groupwise? | Excel Discussion (Misc queries) | |||
| can't email excel file as an attachment | Excel Discussion (Misc queries) | |||
Hybrid Mode
