Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I copied the code from Ron de bruin's website that will mail every WS with
an address in cell A1. However, the code stops right at the .send and I can't figure out what is wrong. (I also copied the function as instructed). I'm using Office 2000 on Win2000. Run=time error '-2147220960(80040220)': I have an address in cell A1 which is valid on sheet1. What could possibly be wrong? Annette |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Annette
You are talking about the CDO example? Have you used the comented lines also to fill in yout SMTP server -- Regards Ron de Bruin http://www.rondebruin.nl "Annette" wrote in message ... I copied the code from Ron de bruin's website that will mail every WS with an address in cell A1. However, the code stops right at the .send and I can't figure out what is wrong. (I also copied the function as instructed). I'm using Office 2000 on Win2000. Run=time error '-2147220960(80040220)': I have an address in cell A1 which is valid on sheet1. What could possibly be wrong? Annette |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I never learn to type English<g
Have you used the commented lines also to fill in your SMTP server -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Annette You are talking about the CDO example? Have you used the comented lines also to fill in yout SMTP server -- Regards Ron de Bruin http://www.rondebruin.nl "Annette" wrote in message ... I copied the code from Ron de bruin's website that will mail every WS with an address in cell A1. However, the code stops right at the .send and I can't figure out what is wrong. (I also copied the function as instructed). I'm using Office 2000 on Win2000. Run=time error '-2147220960(80040220)': I have an address in cell A1 which is valid on sheet1. What could possibly be wrong? Annette |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error "invalid data source reference" for pivot table | Excel Worksheet Functions | |||
error: "invalid character in text conent" How do I open this file | Excel Discussion (Misc queries) | |||
"Invalid Web Query" error on opening a 2003 worksheet | Excel Discussion (Misc queries) | |||
RunTime Error "1004" QueryTable is Invalid | Excel Programming | |||
Need help in excel with "Statement invalid outside Type block. " error | Excel Programming |