Attachment Gets Skipped Code Becomes Slow

Hello Forum,
I am using the following code to generate 5000 E mails with a PDF attachment which lives on my desktop. Problem is:
1/ Attachment does not show up when I use "SEND “or "DISPLAY". After few e mails are generated.
2/The code is too slow to respond and takes good amount of time to generate e mails, after a while, and slows down too much ,excel also crashes, is it because of the size of database, as I am using it to generate around 5000 e mails at a go .Any assistance will be highly appreciated.
Here is the code for review:

Please Login or Register  to view this content.

Hi N
You've asked me via PM to look at this Thread. Sending that many emails at "a go" (your term) sounds like spam to me...and perhaps to your Email Client also.

My Email client (Roadrunner) allows me to send up to 100 email addresses in an email. I've built a work around that creates multiple "Distribution Lists" such that I can send the same email to more than 100 (in my case, 120).

I can't imagine a legitimate business reason to send 5000 emails at "a go". You'll need to make a STRONG argument to get help on this issue.

Yes J you are right here even I might have suspected anyone who is crazy to be sending 5000( now it 7242,as per the last count ) e mails at a go..But If you remember I mentioned sendind e mails to vendors requesting them to care for enviornment and opt for electronic document in place of physical one and I need to send them sample for what documents gonna look like,to get them to approve it.Please refer to : http://www.excelforum.com/outlook-pr...ttachment.html Post # 1