I have created a custom form in Outlook to gather information about components that go into a manufactured product. When I open an email containing this form I can press "Tools"->"Forms"->"Design this Form" and some other tabs appear including a tab called "All Fields". I can open this tab, go to Edit, Select All then copy and paste this to an Excel spreadsheet.
Is there any way I can have Outlook (when I open the email or otherwise) to automatically copy this tab to an Excel spreadsheet using the subject line from the email as the title of the Spreadsheet? or can I save these emails in a particular way as a database and have Excel find it?
Thanks in advance for any help that you can give.