Email results in infinite loop

[LewisBosworth]

Hi all,

The following opens a new email and pastes an image, ("Group 1") into the body. Problem is, after the PasteAndFormat line, the code appears to restart instead of moving to the next line. Can someone explain why and how to fix this?

[Logit]

.
You can try placing a EXIT SUB in one of two areas as indicated below :

Please Login or Register  to view this content.

[Greg M]

Hi there,

If you're using the F8 key to step through your code, the routine will indeed appear to stop, because the yellow highlighted line will disappear as soon as the PasteAndFormat command has executed.

However, by inserting the highlighted rows in the following code you will see that the routine does in fact complete its execution:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[LewisBosworth]

Thanks guys for looking at this. As it turns out Greg was correct... I was stepping through with F8 and I was expecting it to step to the next, but instead it just started the sub over again. I mistook it for an infinite loop, i.e. I tricked myself. My sincere apologies for the time wasted to look at this.

Lewis

[Greg M]

Hi again,

Many thanks for your feedback.

No need for apologies - glad I was able to help.

Regards,

Greg M

[Logit]

.
Glad you found your answer.

[Greg M]

Hi again,

Many thanks for the Reputation increase - much appreciated!

Glad I was able to help.

Best regards,

Greg M