Forum

SharePoint metadata...
 
Notifications
Clear all

SharePoint metadata into Word

3 Posts
2 Users
0 Reactions
67 Views
(@paul-sanft)
Posts: 35
Trusted Member
Topic starter
 

Hi,

Is there a VBA code to take a component of metadata from a DOCSET in SharePoint and automatically insert it into a Table in Microsoft Word?

i.e. If a component of  metadata is a 'surname' then whenever a new item is created inside the DOCSET that information is inserted/embedded in the document  

 

Thanks in Advance 

 
Posted : 16/02/2023 10:27 pm
(@catalinb)
Posts: 1937
Member Admin
 

Hi Paul,

Are you sure VBA is the one for this task?

Power Automate looks more appropriate for this, it has the tools to monitor sharepoint to see when an item is created, it can also control other office apps to write into a template.

 
Posted : 19/02/2023 1:42 pm
(@paul-sanft)
Posts: 35
Trusted Member
Topic starter
 

Hi Catalin,

 

I woulkd love to use Power Automate, unfortunately my employer is a lomg way behind with applications (stuck in the dark ages) so I am very limited as to what I can do.

 

Regards

 
Posted : 07/03/2023 4:37 pm
Share: