ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Run-time Error in "SENDUSING" configuation value is invalid (https://www.excelbanter.com/excel-programming/293790-run-time-error-sendusing-configuation-value-invalid.html)

Annette[_3_]

Run-time Error in "SENDUSING" configuation value is invalid
 
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



Ron de Bruin

Run-time Error in "SENDUSING" configuation value is invalid
 
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





Ron de Bruin

Run-time Error in "SENDUSING" configuation value is invalid
 
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








All times are GMT +1. The time now is 08:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com