Forum Discussion
Linking excel to word to collect data
Joey_P258 Theoretically you could use the mail merge functionality to pull excel data into word and place in into specific locations within that document. Without knowing how complex your quote form is, it's hard to say if that's more efficient than just copy/pasting.
As I'm thinking, I'm wondering if using Microsoft "forms" might be an option. This is a different workflow than you described, but once a quote form is completed, all data entered would be stored in excel. It auto creates a new row/record each time the form is filled out. While you can create a custom list using drop downs of various products/services, I don't see an option to auto update those dropdown lists based on data coming from excel. This is one drawback.
Unfortunately, those are the only two ideas that come to mind at this point.
- Joey_P258Aug 26, 2022Copper Contributor