Python Forum
Looking to automate updating a spreadsheet with image from email
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Looking to automate updating a spreadsheet with image from email
#1
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?
Reply
#2
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.
Reply
#3
Can anyone offer suggestions or whether this is possible?
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Returning Column and Row Data From Spreadsheet knight2000 0 451 Oct-22-2023, 07:07 AM
Last Post: knight2000
  Editing spreadsheet/csv BSDevo 6 1,044 Sep-01-2023, 05:47 PM
Last Post: BSDevo
  Save image from outlook email cubangt 1 708 Jun-07-2023, 06:52 PM
Last Post: cubangt
  Import XML file directly into Excel spreadsheet demdej 0 860 Jan-24-2023, 02:48 PM
Last Post: demdej
  is it possible to copy image from email and place into excel file? cubangt 3 1,283 Nov-30-2022, 05:11 PM
Last Post: snippsat
  updating Google spreadsheet with gspread mgallotti 0 1,105 Sep-30-2022, 11:26 PM
Last Post: mgallotti
  Modify LibreOffice's ods spreadsheet Pavel_47 0 1,190 Jul-13-2022, 11:28 AM
Last Post: Pavel_47
  Python create a spreadsheet with column and row header ouruslife 4 1,648 Jul-09-2022, 11:01 AM
Last Post: Pedroski55
  Searching for URLs and printing the corresponding row from an Excel spreadsheet johnbernard 0 1,285 Aug-20-2021, 06:43 PM
Last Post: johnbernard
  "Switch-to-spreadsheet" entry. Feasible in Python? whatspython 2 2,029 Sep-30-2020, 01:12 PM
Last Post: buran

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020