Power Platform Community Forum Thread Details

Im trying to Copy Excel Table Data & Paste Specified Book Mark in MS Word Doucment by PowerAutomate Desktop Tool,

But In Automate Tool, No have features MS Word Activities.

So, I want to get a PowerShell script code that pastes the clipboard to a specific bookmark in the MS Word file.

Please Reply to me! If someone Help it, I will very appreciate it.

Thanks 🙂

Categories:

I would suggest that instead of using the clipboard, you would simply read data from Excel using Read from Excel worksheet and store it into a variable. If you use scripting, formatting will not be pasted anyway.

When you have the data in a variable, you can use VBscript or PowerShell to write to an MS Word document. It is quite easy to find sample code on how to do it online.

Alternatively, you could launch MS Word and simply use Send keys to paste the data, if you need it to retain formatting, too. This will be slow, inefficient and with a higher potential for error. But that's pretty much the only way to copy and paste data with formatting.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.