![]() |
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