paste from excel overwrites in Word document

[bob33]

I've a worksheet with blocks of text associated with a name on the same row.
I'm searching for the name, then copying the block of text into a Word document.
The loop works but it overwrites the prior text copied into the Word document.
I tried an .InsertBreak but that didn't work.
Help is appreciated!

Please Login or Register  to view this content.

[hafizimran]

Just replace your line 'AppWord.ActiveDocument.Content.Paste' with

Please Login or Register  to view this content.

then your code will be:

Please Login or Register  to view this content.

[bob33]

Thank you! That works great.
Now, a problem I see now that it is working.
I need to identify the name of the person (name1 or name2) the blocks of text pasted into the Word doc belong to.
Right now, they all run one after another and I need to group them by name1 or name2 in the Word doc.
I tried to paste name1 into the doc in the loop but either I got it repeated endlessly.
Suggestions?

[bob33]

I got the name to be inserted before the associated blocks of text.

The output format in the Word document (attached) is in table cells all about the same size. Is there a way to resize the table cells in Word doc to fill available page width?


Current code:

Please Login or Register  to view this content.

Thanks!