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 "Thumbs Up" 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 "Thumbs Up" icon, below, in the bottom right corner:)