I have created a custom form in Outlook for the sales department to record data to send to the manufacturing department that provides details on the components that go into a new product. After the email is received its possible to go to "Tools"->"Forms"->"Design this Form". I then select the "All Fields" tab. Press "Select All" in the "Edit" menu and then cut & paste into an Excel spreadsheet called "New Data".
I am hoping someone can help me with a macro that will select the right hand column only and paste to the spreadsheet in successive columns.
Is there a way to link the fields of a custom form to an Excel spreadsheet.
Thanks for an help you can give.