Attachement to Email Please help

[bimo]

Hello

Hello

This Code meant to Create a Sheet from details of Pivot table,
move the sheet to New Workbook
save the new workbook
Attach the New Workbook to an email

Everything it is fine except the Email message has no attachement

Any Idea where it went wrong ?

Thanks

Please Login or Register  to view this content.

[judgeh59]

try something like this....untested...

Please Login or Register  to view this content.

[bimo]

it didn`t like it, I had to define a variable then it worked...Thanks anyway

Please Login or Register  to view this content.

[judgeh59]

I wasn;t sure about that....that is the way I have in my code but I was trying match with your stuff....I'm glad it worked...

[judgeh59]

Thanks for setting the thread to Solved...If you feel I deserve an increase in my reputation, feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be me...just a thought...