Email With Attachments - Failing

[Logit]

.
.
The following code is ever present on numerous websites. In general it works, but not well. Oftentimes not all of the email addresses are sent and/or the attachments are either duplicated or not sent at all.
I don't understand alot about linking to Outlook and lack sufficient expertise to troubleshoot.

I suspect the examples posted on websites provide just enough to function but lack everything needed to do so completely (of course I could be wrong again )

So ... what's missing or what is wrong with my computer ? (I added the time delay to give the code an opportunity to 'work' more efficiently - on my computer it made a slight difference of improvement)

Please Login or Register  to view this content.

[mehmetcik]

I had issues for a long while.

Then I realised that Outlook had a max size of attachment setting.

I increased that and my problems disapeared.

[Logit]

Look at the settings. Well within the limits.

Thank you for the suggestion.

Merry Christmas !

[bakerman2]

How about this.

Please Login or Register  to view this content.

[Logit]

I did some testing with increasing the delay time between email sends.

The X's indicate how many times that specific email message was received and the numbers adjacent to the X's indicate the order received in mailbox.

Interesting that 5 seconds seems to cover all the emails (and sending each one twice by list) yet some of the emails were sent three times although the code doesn't indicate such.

.Row 3, 5 sec should have three x's to indicate three separate emails coinciding with receive sequence: 14 , 17 , 19


.
.Email.jpg

[Logit]

bakerman2

Had to add some DIM statements .... not working. Not sending any emails at all - nothing received. This is what I have so far.

It's late, will check this thread in morning. Thank you.

Please Login or Register  to view this content.

[bakerman2]

Had to add some DIM statements

That's what you get when using Option Explicit. (I never do)

Then, what's the rw doing in the code. You initialize it but then do nothing to give it a value.
So in short, loose the Option Explicit and try my code as is.

[Logit]

Removing Option Explicit the code fails on:

Please Login or Register  to view this content.

With error code "Item Moved or Deleted"

Nothing changed in the attachment listings or their location.

It manages to send two emails but no more. One of the emails has an attachment that isn't listed in Col B. Unusual ...

================================================================================================

I believe what is happening with my code pertains to the speed / ability of my internet connection to 'accept' each email as it is being sent. It may also
involve my modem or some other component of connection to the internet / ISP. With the built in delay my system has the opportunity to actually send an
email before presented with another one that needs sending.

Is that reasonable or am I grasping at straws ?

[bakerman2]

You could also delay execution a bit more by adding a check if attachment exists to each loop.(which isn't that a bad idea after all)
If your connection speed is really the cause then delaying each loop might in fact be the only option.

[Logit]

Thank you for the reply.

Please provide example code for checking if the attachment exists. Hopefully, that would assist with the code not selecting something close to the attachment name if the attachments are located in a directory with
a number of 'non-listed' files.

Does that make sense or should all of the attachment files always be located in a separate folder by themselves ?

[bakerman2]

Check out the Dir function to check if a file exists or not.
Normally it shouldn't make a difference that all files are in 1 directory.

[Logit]

Thanks bakerman2.

Merry Christmas !

[bakerman2]

You're welcome and thanks for adding rep points.
Merry Christmas to you too.