Email daily comments on (multiple) sheets
This seems pretty basic, so not sure if I'm missing something. But, certain project stakeholders like to receive daily status emails that show the project activity. When I say activity, I mean comments, not who changed which cell. Currently the only way I've been able to do this is the literally grab screenshots of the comments from the comment pop up window 1, 2 or 3 at a time. I'm unable to copy and paste the text from this pop up. I would use the export function, but the comments are not given any context, so I'd have to see if I could build an excel template that I could paste into and perhaps it would do some vlookups. I may have to go this route. But, seems strange that there is no easy to just grab the comments for the day and put them into an email.