Problem with VBA code to attach file to email using a pre saved Outlook template

[Wooltrain]

Hello,

Forgive me for being somewhat of a novice with macro coding but I have a code that works for me on my computer but does not work when my colleagues attempt to do so on theirs.
Background: I have an inventory update file that I prepare for my colleagues each day. Many of the functions that create the update file are controlled by macros. To make the update and distribution of the file as quick and simple as possible I wrote a macro to attach the file to an Outlook template. The Outlook template contains a whole lot of information in the body and all the email addresses of the recipients. I attached that macro to a command button on the form.
It works great for me. I click the command button and everything works.
But when I am not in the office, the update function and distribution needs to be handled by someone else. For that reason, I stored the Outlook template (otf file) on one of our network drives.

However, when my colleagues attempt to run that macro on their computer it does not send the email.
Here is the code:

Please Login or Register  to view this content.

Any help with what I'm doing wrong here would be greatly appreciated.
Thank you.

[Richard Buttrey]

Hi,

Which line is highlighted when the error occurs?

Would you also add code tags to your original post - as required by our rules.

[Wooltrain]

Hi Richard,

That's the strange thing, the macro runs all the way through. It doesn't throw up an error.
No debug messages. No highlighted code.
It behaves as if it has worked but the email never gets sent.

This code works just fine on my computer. Everything behaves as expected. It is only when I try and run it on a different machine that the email does not send.

[aarona]

Hi Wool,

try to remove the on error resume next so that you can see which error will be highlighted.

[Wooltrain]

Hi all,

I removed the "on error resume next" and ran it on three different computers.
The macro worked perfectly each time.
Still no errors showing, but it's working!

Thanks for the assists!