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!