Results 1 to 1 of 1
Thread: Custom Form Macro (2000)
2002-04-16, 16:29 #1
- Join Date
- Jan 2002
- Trenton, Ontario
- Thanked 0 Times in 0 Posts
Custom Form Macro (2000)
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.