from MS Access to MS Word tables

[matto]

Hey!!

I've got a string that I've populated with data (from MSAccess...) and I want to insert this data into a table (in MS Word).



There are two columns (midwayish... columns 3 and 4) in the table that this data should go into. I've got the first cell where data should go bookmarked as "police".

I've got a string called cops filled with the information as such (so far): "name" & vbTab & "number" & vbCr & "name2" & vbTab & "number2" & vbCr(etc)

Now if there was a character that reprsented the arrow keys on the keyboard, I could simply replace vbTab with the Right arrow key, and vbCr with a Down and Left arrow key maneuver and that would be problem solved. But I don't know if this is possible.

If that were the case, this would be all I'd have to do:

.ActiveDocument.Bookmarks("police").Select
.Selection.Text = (cops)

Any ideas on how to do this?

[NTC]

I would use the generic Wordmerge capabiility of Word. It is able to use an Access query as it's data source easily.

[matto]

Nifty feature that I did not know about! Unfortunately, I don't think it'll work with what I'm doing. And I've already come this far, so I'm just going to improvise, merge some cells, and have it spit out a bunch of stuff in one cell of one column, and do the same for the next column, etc. It'll have to do.

Thanks for the suggestion, though.