|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Excel vb Email
Hi Jonathan
Try point 2 on this page http://www.rondebruin.nl/sendmail.htm#Problems Please post back with the result -- Regards Ron de Bruin http://www.rondebruin.nl "Jonathan" wrote in message news:oGjdc.23654$J56.23460@edtnps89... 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 |
Excel vb Email
Editing the win.ini file as suggested work.
Thanks for all the help. Jonathan "Ron de Bruin" wrote in message ... Hi Jonathan Try point 2 on this page http://www.rondebruin.nl/sendmail.htm#Problems Please post back with the result -- Regards Ron de Bruin http://www.rondebruin.nl "Jonathan" wrote in message news:oGjdc.23654$J56.23460@edtnps89... 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 |
Excel vb Email
Thanks for the feedback
-- Regards Ron de Bruin http://www.rondebruin.nl "Jonathan" wrote in message news:WSjdc.7584$mn3.1252@clgrps13... Editing the win.ini file as suggested work. Thanks for all the help. Jonathan "Ron de Bruin" wrote in message ... Hi Jonathan Try point 2 on this page http://www.rondebruin.nl/sendmail.htm#Problems Please post back with the result -- Regards Ron de Bruin http://www.rondebruin.nl "Jonathan" wrote in message news:oGjdc.23654$J56.23460@edtnps89... 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 |
| All times are GMT +1. The time now is 03:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com