Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Visual Basic Error Run Time Error, Type Mismatch Meg Partridge Excel Discussion (Misc queries) 12 September 10th 08 06:10 PM
Run Time Error 1004: Application or Object Defined Error BEEJAY Excel Programming 4 October 18th 06 04:19 PM
Run Time 1004 Error: Application or Object Difine Error BEEJAY Excel Programming 0 October 17th 06 10:45 PM
run-time error '1004': Application-defined or object-deifined error [email protected] Excel Programming 5 August 10th 05 09:39 PM
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error rdavis7408 Excel Programming 1 August 25th 04 03:54 AM


All times are GMT +1. The time now is 11:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"