ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   run time error (https://www.excelbanter.com/excel-programming/378821-re-run-time-error.html)

NickHK

run time error
 
David,
I would guess it has something to do with how you construct your send_to
value.
Add a line
Debug.print send_to
just before to see what it evaluates to.

NickHK

"David Gerstman" wrote in message
...
My e-mail program works. Once.
The second time through the loop though I get errors such as:
Automation error or item has been moved or deleted (both are listed as Run
Time errors followed by some large negative number.

On Knowledge base I've found indications that this could be a security
issue. However since I've run similar code before with no problem, I don't
think that's the problem. Is there any action I should have taken and

didn't
(or not taken and took) that would account for such errors. The error
specifically hits at the ".To" line below.

With OutMail
.To = send_to
.Subject = sub_line
.Body = sum_text
.Send
End With

David





All times are GMT +1. The time now is 10:01 AM.

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