Python Forum

Full Version: Looking to automate updating a spreadsheet with image from email
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
ok, so at work we have an email that is sent out daily each morning.. in this email the body contains a image of a graph.(screenshot)
Within teams / sharepoint we have a report that is displayed on our meeting room tv's which is an excel file that has a tab with just this graph for displaying purposes.

I have automated a number of things using python, spreadsheets, pivots and more..including pulling files from outlook... but looking to see if i can grab this screenshot from the said email, then paste that image into the excel file that is being presented.

not sure what i can provide as example, since its not formulas or anything, just need help on how to extract a image from an image, where the images is in the body of the email.. "copy" that image, open this excel file thats in teams/sharepoint and paste it into the graph tab.

Can anyone point me in the right direction?
Let me add by saying that i already have and know how to connect to outlook and into the correct folder to find the emails with the screen shots, the first thing i need help with is how to grab the screenshot from the body of the email, and to check and make sure there is an image to grab so that im not processing invalid emails, since other emails are sent to this same mailbox for other subjects.
Can anyone offer suggestions or whether this is possible?