I need to put data from MS query into a word document. the document is formatted and will need data put in specific portions of the word document. I will provide the query you will use to get the data so you can write macros and logic for the word document.
Data will have to be separated from leading and following characters. Example KD: 20 - :XKD shall be codes to find KD: 20 - :XKD and the remove the KD: and the remove :XKD so the text reads 20 -
the query will pull the data based on a number typed into Word or Excel. Attached is the word document.
The query I give you will give you the data needed to fill out this word document.
The computer will be loaded with office 2007.
Questions are welcome