I am building an interactive calculator.. See this thread.
When something is entered in to J13 of this spreadsheet, i want the spreadsheet to create a new Outlook email, with a set subject.. and in the body of the email, i want it to reference the output from H15 and K17 in the body of the email.
An example.. Customer enters "60" in J13. the output in H15 is FGXMPMPAD-MBF060, and a price comes up of $1000.00. I want an outlook "new email" window to popup, subject is "MPO Priced", and body of the email to read "I've built a price for FGXMPMPAD-MBF060, at $1000.00". And i want it to go to a set email address, and CC a few others..
Is this possible? hopefully it makes sense.. A copy of the spreadsheet can be found in the original email..
Thanks!
Bookmarks