| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel vb Email
Hello.
I am looking for some help with a function to send a workbook by email without knowing whether the user has outlook or outlook express. I can make the funtion work with either email program but not both. I am using Office 2000. Thanks Jonathan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel vb Email
Hi Jonathan
You can use this example from my site http://www.rondebruin.nl/sendmail.htm#Workbook You only can send a workbook that is open if you want to use code that will work in both programs -- Regards Ron de Bruin http://www.rondebruin.nl "Jonathan" wrote in message news:uridc.23608$J56.13776@edtnps89... Hello. I am looking for some help with a function to send a workbook by email without knowing whether the user has outlook or outlook express. I can make the funtion work with either email program but not both. I am using Office 2000. Thanks Jonathan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel vb Email
Thanks for the quick response....
I am using this exact code ActiveWorkbook.SendMail ", "This is the Subject line" and have tried Application.Dialogs(xlDialogSendMail).Show "), ("hi") Both of these work in Outlook without problem but refuse to work in outlook express (Outlook express version is 6.00) I have tried with outlook express open and closed and outlook is the default mail program. Any hints would be great. Thanks Jonathan "Ron de Bruin" wrote in message ... Hi Jonathan You can use this example from my site http://www.rondebruin.nl/sendmail.htm#Workbook You only can send a workbook that is open if you want to use code that will work in both programs -- Regards Ron de Bruin http://www.rondebruin.nl "Jonathan" wrote in message news:uridc.23608$J56.13776@edtnps89... Hello. I am looking for some help with a function to send a workbook by email without knowing whether the user has outlook or outlook express. I can make the funtion work with either email program but not both. I am using Office 2000. Thanks Jonathan |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel vb Email
sorry I meant to say outlook express is the default program not outlook
"Jonathan" wrote in message news:Xejdc.23646$J56.12915@edtnps89... Thanks for the quick response.... I am using this exact code ActiveWorkbook.SendMail ", "This is the Subject line" and have tried Application.Dialogs(xlDialogSendMail).Show "), ("hi") Both of these work in Outlook without problem but refuse to work in outlook express (Outlook express version is 6.00) I have tried with outlook express open and closed and outlook is the default mail program. Any hints would be great. Thanks Jonathan "Ron de Bruin" wrote in message ... Hi Jonathan You can use this example from my site http://www.rondebruin.nl/sendmail.htm#Workbook You only can send a workbook that is open if you want to use code that will work in both programs -- Regards Ron de Bruin http://www.rondebruin.nl "Jonathan" wrote in message news:uridc.23608$J56.13776@edtnps89... Hello. I am looking for some help with a function to send a workbook by email without knowing whether the user has outlook or outlook express. I can make the funtion work with either email program but not both. I am using Office 2000. Thanks Jonathan |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel vb Email
Do you get errrors? -- Regards Ron de Bruin http://www.rondebruin.nl "Jonathan" wrote in message news:Ufjdc.23647$J56.9657@edtnps89... sorry I meant to say outlook express is the default program not outlook "Jonathan" wrote in message news:Xejdc.23646$J56.12915@edtnps89... Thanks for the quick response.... I am using this exact code ActiveWorkbook.SendMail ", "This is the Subject line" and have tried Application.Dialogs(xlDialogSendMail).Show "), ("hi") Both of these work in Outlook without problem but refuse to work in outlook express (Outlook express version is 6.00) I have tried with outlook express open and closed and outlook is the default mail program. Any hints would be great. Thanks Jonathan "Ron de Bruin" wrote in message ... Hi Jonathan You can use this example from my site http://www.rondebruin.nl/sendmail.htm#Workbook You only can send a workbook that is open if you want to use code that will work in both programs -- Regards Ron de Bruin http://www.rondebruin.nl "Jonathan" wrote in message news:uridc.23608$J56.13776@edtnps89... Hello. I am looking for some help with a function to send a workbook by email without knowing whether the user has outlook or outlook express. I can make the funtion work with either email program but not both. I am using Office 2000. Thanks Jonathan |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel vb Email
I get the error "Runtime 1004 Show method of dialog class failed" when using
the below code Application.Dialogs(xlDialogSendMail).Show "), ("hi") and the error "Method 'SendMail' of object '_Workbook' failed" with the code ActiveWorkbook.SendMail ", "This is the Subject line" Jonathan "Ron de Bruin" wrote in message ... Do you get errrors? -- Regards Ron de Bruin http://www.rondebruin.nl "Jonathan" wrote in message news:Ufjdc.23647$J56.9657@edtnps89... sorry I meant to say outlook express is the default program not outlook "Jonathan" wrote in message news:Xejdc.23646$J56.12915@edtnps89... Thanks for the quick response.... I am using this exact code ActiveWorkbook.SendMail ", "This is the Subject line" and have tried Application.Dialogs(xlDialogSendMail).Show "), ("hi") Both of these work in Outlook without problem but refuse to work in outlook express (Outlook express version is 6.00) I have tried with outlook express open and closed and outlook is the default mail program. Any hints would be great. Thanks Jonathan "Ron de Bruin" wrote in message ... Hi Jonathan You can use this example from my site http://www.rondebruin.nl/sendmail.htm#Workbook You only can send a workbook that is open if you want to use code that will work in both programs -- Regards Ron de Bruin http://www.rondebruin.nl "Jonathan" wrote in message news:uridc.23608$J56.13776@edtnps89... Hello. I am looking for some help with a function to send a workbook by without knowing whether the user has outlook or outlook express. I can make the funtion work with either email program but not both. I am using Office 2000. Thanks Jonathan |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel vb Email
Hi Jonathan
and outlook is the default mail program Is this a typo? If not change it to Outlook Express StartSettingsControl Panel....Internet options (Program Tab) Close Excel first before you make a change. -- Regards Ron de Bruin http://www.rondebruin.nl "Jonathan" wrote in message news:Xejdc.23646$J56.12915@edtnps89... Thanks for the quick response.... I am using this exact code ActiveWorkbook.SendMail ", "This is the Subject line" and have tried Application.Dialogs(xlDialogSendMail).Show "), ("hi") Both of these work in Outlook without problem but refuse to work in outlook express (Outlook express version is 6.00) I have tried with outlook express open and closed and outlook is the default mail program. Any hints would be great. Thanks Jonathan "Ron de Bruin" wrote in message ... Hi Jonathan You can use this example from my site http://www.rondebruin.nl/sendmail.htm#Workbook You only can send a workbook that is open if you want to use code that will work in both programs -- Regards Ron de Bruin http://www.rondebruin.nl "Jonathan" wrote in message news:uridc.23608$J56.13776@edtnps89... Hello. I am looking for some help with a function to send a workbook by email without knowing whether the user has outlook or outlook express. I can make the funtion work with either email program but not both. I am using Office 2000. Thanks Jonathan |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel vb Email
Yes it was a typo it should have read outlook express
Jonathan "Ron de Bruin" wrote in message ... Hi Jonathan and outlook is the default mail program Is this a typo? If not change it to Outlook Express StartSettingsControl Panel....Internet options (Program Tab) Close Excel first before you make a change. -- Regards Ron de Bruin http://www.rondebruin.nl "Jonathan" wrote in message news:Xejdc.23646$J56.12915@edtnps89... Thanks for the quick response.... I am using this exact code ActiveWorkbook.SendMail ", "This is the Subject line" and have tried Application.Dialogs(xlDialogSendMail).Show "), ("hi") Both of these work in Outlook without problem but refuse to work in outlook express (Outlook express version is 6.00) I have tried with outlook express open and closed and outlook is the default mail program. Any hints would be great. Thanks Jonathan "Ron de Bruin" wrote in message ... Hi Jonathan You can use this example from my site http://www.rondebruin.nl/sendmail.htm#Workbook You only can send a workbook that is open if you want to use code that will work in both programs -- Regards Ron de Bruin http://www.rondebruin.nl "Jonathan" wrote in message news:uridc.23608$J56.13776@edtnps89... Hello. I am looking for some help with a function to send a workbook by without knowing whether the user has outlook or outlook express. I can make the funtion work with either email program but not both. I am using Office 2000. Thanks Jonathan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| send email to each customer email in excel sheet. | Excel Discussion (Misc queries) | |||
| Email addresses in Excel need to format for mass email | Excel Worksheet Functions | |||
| Email editor closes when forwarding Excel-embedded email | Setting up and Configuration of Excel | |||
| working on excel document in email saved changes in email not in . | Excel Discussion (Misc queries) | |||
| body of email disappears when I send an email from Excel | Excel Discussion (Misc queries) | |||
![Jonathan[_11_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
