Paste

[Homegrownandy]

I want to copy rows of a table from excel into a word table. Which I am doing, but when the data I am copying is from an access database link the only formatting option that works is "Paste options: merge"



I've looked online for a while, found nothing. I've tried recording macros in both excel and in word, I cant get that working either.

All I need to know is how to paste that option using VBA, if someone knows that would help greatly.

thanks, Andy

Edit: I cant change the title, that was a temporary one.

[Homegrownandy]

cross reference:

https://www.ozgrid.com/forum/forum/h...nto-word-merge

[Homegrownandy]

Another cross reference:
http://www.msofficeforums.com/word-v...ord-table.html

Begining to think its not possible.

[Micron]

I presume you mean to output each record in a table row. While I have no experience doing that in Word, I have in Excel and am pretty sure a mass copy/paste can't be done there either. The closest thing would be transferspreadsheet, which works between a table and spreadsheet (in either direction) but that's not a copy/paste operation. The usual method outside of copy/paste would be Automation, so I'm guessing that if one can do that in Excel, one could move through a set of Word table rows and cells, inserting table field values, but I've never done that.

If you mean to dump a set of records into one table row, then I have no idea, other than separately concatenating record values down each of the Access fields and inserting into a Word table cells.