Need Help with Code to auto close and save emails to draft folder

[katalyzt_94]

Hello!

Wanted to see if someone can help add a code to the attached file that will auto close and save the emails to the Drafts folder in Outlook once they have been generated by clicking on the picture.

Please let me know if this is possible to do.

Thank you

[cytop]

It should be as simple as Saving (goes to Drafts by default) and then Closing the window...

Please Login or Register  to view this content.

You do realise you could drastically reduce the amount of code by looping through the range instead of processing each individual cell...?

[katalyzt_94]

Thanks, this extra code appears to save each email but it doesn't automatically close them. Wondering if it can also close each email so that they don't stay open on the screen.

[cytop]

Been a while since I worked with Outlook - Totally forgot about the 'Inspector'

Please Login or Register  to view this content.

Plus, if each 'block' in your original code was identical except for the cell used to pick information then that above should loop from B3 to the last used cell in B, ignoring any intermediate blanks

[katalyzt_94]

Excellent! This works exactly like I wanted and thanks for reducing the amount of code needed! You're awesome!