Hi Paul, Sorry for the delay.

this is the closest thing I have seen to something that works.

Also sometimes it pastes the table at the very top of the document not at the bookmark. I tried to add a 2 second delay but this problem still happens sometimes.

it seems about 50/50 if it actually pastes in the bookmark. But its not always predictable sometimes you get two good ones in a row sometimes two bad ones. I have similar code importing data from access which works without issue on the same document. Maybe its an issue with doing this with a table of data rather than one field.

If you have any ideas I would love to hear them,

Thanks a lot, Andy.