Datafile for mailmerge in word

[John]

Hi

How can I turn an sql string in my vb app into datasource for a word
mailmerge? This example (below) tries to fill the data manually, a row at a
time which is too time consuming and also user sees the data filled one
field at a time which is not ideal.

http://support.microsoft.com/defaul...port/kb/articles/Q301/6/56.ASP&NoWebContent=1

Is there a better way to do this?

Thanks

Regards

 

[guy]

Hi,
Have you experienced this method in webform (AspNet)
instead of Windows App?
Best regards

 

[John]

No. Just the windows app.

Hi,
Have you experienced this method in webform (AspNet)
instead of Windows App?
Best regards

 

[Cindy M -WordMVP-]

Hi John,

It makes me feel ill everytime I see the code in one of these articles...

Certainly there's a better way!

1) You can simply create a delimited text string, save that to file and use it as a data source.

2) Since some versions of Word in certain configurations have issues with *.txt files, you mihgt want to dump the string into Word
and save it in Word document format

3) If you really WANT a Word table as the data source, then place the string into a Word RANGE, then use the ConvertToTable
method on the range

The last thing you ever want to do when automating Word is to create and fill in a table cell-by-cell.

How can I turn an sql string in my vb app into datasource for a word
mailmerge? This example (below) tries to fill the data manually, a row at a
time which is too time consuming and also user sees the data filled one
field at a time which is not ideal.

http://support.microsoft.com/defaul...port/kb/articles/Q301/6/56.ASP&NoWebContent=1

Is there a better way to do this?

-- Cindy