Automated Word Document from Sharepoint

Question

Hello,

I'm looking for some ideas on how to create an automated word document from a sharepoint list. Essentially the sharepoint looks like this:

Column Project Project Scope Project Update Project Manager
Row
1 Name 1 Scope 1 Update 1 PM 1
2 Name 2 Scope 2 Update 2 PM 2
3 Name 3 Scope 3 Update 3 PM 3
4 Name 4 Scope 4 Update 4 PM 4
5 Name 5 Scope 5 Update 5 PM 5
... ... ... ... ...

And I would like to automatically print a microsoft word document that would look like this:

Project 1
"Scope:" 'Column A:Row1'
"Update:" 'ColumnA:Row2'
Etc............

I would like to do this for all of the projects that we have, which is in the hundreds. I thought that the best way to do this would be a loop function in VBA, however I'm not super familiar with VBA so I thought that I might be able to gauge feasibility on using this method here. Even if I have to export to excel that would be alright.

I also want to be able to do formatting inside the code (font, size, style), so I thought VBA would be the way to go.

I am open to any other ideas to best accomplish this.

Thank you!

Answer 1

Per my knowledge, you may be able to do it after your export the list to Excel with VBA. As I am not quite familiar with Office VBA, I cannot provide much help about this.

For using SharePoint Online, there is another approach using Power Automate. You can populate a word template and insert the required value into specified position with a word template. Here is a tutorial video for your reference