Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Run Time Error 1004: Application or Object Defined Error | Excel Programming | |||
Run Time 1004 Error: Application or Object Difine Error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming |