Mr. Walnuts
Board Regular
- Joined
- Aug 8, 2005
- Messages
- 176
Im looking to create an excel document with a database array. I am going to populate the db with form data that I would like to be able to query with a macro to fill a predetermined Word document.
How would I go about creating a macro that would create and fill a word document template with 3 values?
Example: Excel sheet
Column A Column B Column C
Name Category Cost
Word Document will have many fields in the template, but only the 3 fields need to autofil based on Excel data.
How would I go about creating a macro that would create and fill a word document template with 3 values?
Example: Excel sheet
Column A Column B Column C
Name Category Cost
Word Document will have many fields in the template, but only the 3 fields need to autofil based on Excel data.