MS Word VBA : How to insert a table of data into a word document ?
Posted on 2007-11-15
Our user need to send out a well formatted letter via MS Word. Yet, on top of the letter itself, in the middle of the letter to the client, we need to insert a table of data (which is the client's transaction details) and the data is resided in our MS SQL server.
My question is : are there any way to let the user to just input a date (in MS Word) and retrieve the relevant data from our MS SQL server and then pass back the data set to MS Word and make it as a table of data within our letter to the client? I have already consider the use of MS EXCEL instead of MS Word (as I never do any programming in MS Word but MS Excel). Yet, our users disagree on this as they already have countless fancy standard letter to client and they don't want to do them again in EXCEL.
Can anyone help? Thanks.