Pasting image to email message

    Hi,

    I have been running this macro which worked great until yesterday. It copies a range & creates a temporary jpg which is supposed to be pasted into the body of an email however since yesterday it has been pasting an old jpg image instead of the current one. I stepped into the code & ran it to the line that copies the range and it is working correctly up to that point. I verified by running it until after the "copy" line, then opening a blank word file & pasting. It is pasting the currently copies image. However if I run the code, it still pasted an old image from 5 days ago to be exact. Can anyone help me out on this?

    Hi,


    In my opinion, the first step would be to clean your temp sub-directory ... in order to re-test your macro ...


    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Did that with no luck. I did however remove the password protections and it started working again. So instead of protecting the sheet, I just applied conditions to the critical cells and that seems to be working. Thank you for taking the time to look.

    Thanks for the feedback.


    Glad you could fix your problem :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login