I have a subscription to emails which contain somewhat consistent content (CRM entries). I'm looking for a way to automate these emails (all from the same sender) to populate a single Excel spreadsheet with a row per email. I can also do a single click macro if that's easier, as I'm no VBA expert. Each email contains a body like below. I'm trying to set it up with the values before the colon as row 1, then populate each row after with the changing values after the :
Type: text
Account: text
Industry: text
Opportunity Name: text
SBU: text
Owner: text
Primary Solution/Project Type: text
Software Platform: text
Duration: text
Sales Stage: text
Revenue: text
Close Date: date
Opened On Date: date
Projected Start Date: date
Opportunity Origin: text
Origin Detail: text
Uses x Resources: text
Estimated x Revenue: text
Project Subcontract %: #
Opportunity Number: #
Reason - Won: text
Is there a predefined script for this, and if not, can someone point me in the right direction?
For the record, I have a rule in Outlook to put all of the emails from the sender (constant) in a folder. It would be nice to be able to run a script for that rule.
Thanks!
Type: text
Account: text
Industry: text
Opportunity Name: text
SBU: text
Owner: text
Primary Solution/Project Type: text
Software Platform: text
Duration: text
Sales Stage: text
Revenue: text
Close Date: date
Opened On Date: date
Projected Start Date: date
Opportunity Origin: text
Origin Detail: text
Uses x Resources: text
Estimated x Revenue: text
Project Subcontract %: #
Opportunity Number: #
Reason - Won: text
Is there a predefined script for this, and if not, can someone point me in the right direction?
For the record, I have a rule in Outlook to put all of the emails from the sender (constant) in a folder. It would be nice to be able to run a script for that rule.
Thanks!
