automatically load table content to campaigns

I want to update a campaign every week automatically with a report in table form that is emailed to me. The report is sent in mhtml format by email, though can also be sent as Image or pdf files and stored at a url. Previously I sent the report by power flow/automate to a list of contacts. Any advice would be appreciated.