Attach File error

[milo1984]

Hi,

Using new Office and suddenly, I have a new error on an old Macro. It attaches an attachment when pressing a commandbutton. below is the code.

Please Login or Register  to view this content.

I get an 'Run Time Error 1004 - Cannot insert object" error.

What do I need to add / change to remove this error?

Many thanks in advance.

[Logit]

.
.
This is what I commented out from the macro ... and it functions well here :

Please Login or Register  to view this content.

[Logit]

.
.
I've experimented with more of the code and have identified the problem (as the code is presently written)
centers on the CommandButton portion.

Specifically this portion with the commented out lines:

Please Login or Register  to view this content.

[milo1984]

Thanks for this. it worked now.

[Logit]

You are welcome. Glad you have it sorted out.