title: How do I use an email link to execute a macro with the message's body used as parameters?
body: <p>I wrote an Excel VBA macro that used a userform to send a form email to an internal manager for approval. I want to write a complimentary macro the same manager can use to relay this information to a different set of internal recipients. The problem I'm trying to wrap my head around is how can I have the manager click an embedded link to another (different) Excel worksheet that would, upon opening, populate the new userform with the information from the email?</p>
  
  <p>To make this idea more clear, the userform collects 5 pieces of information:</p>
  
  <p>MPL(master price list) serial number, Effective date, Manager's name, Impact (yes/no), User's name (derived from application.username)</p>
  
  <p>This information gets emailed to the manager for approval, with a link embedded to another macro enabled workbook on the server where the manager can compose another email using a userform with the same information plus extra account-specific information. The problem I'm trying to solve is how can I take the email body's contents as parameters when the second macro/workbook is opened (so I can auto-fill the second userform).</p>
  
  <p>Let me make this clear: I DO NOT WANT CODE WRITTEN FOR ME! I just want an answer to a conceptual question. Can this even be done? Is there a better way to execute this I'm not seeing?</p>
  
  <p>Thanks in advance.</p>
  
  <p>JSR</p>