Word 2010

iksotof
3StarLounger
Posts: 315
Joined: 04 May 2010, 15:18

Word 2010

Post by iksotof »

Hello

I have a couple of related contract documents where I pre populate certain areas before sending for signing. It is a repeitive task that I would like to automate. Is there a solution where I can type the details needed say once in a table/spreadsheet etc then run a macro to auto opy an paste across to the docuements in question?

Many thanks Darren.

User avatar
HansV
Administrator
Posts: 78530
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Word 2010

Post by HansV »

You could create links to a cell in an Excel worksheet, and lock the links for updating (Ctrl+F11) or break the links (Ctrl+Shift+F9) when the documents are finalized.
Best wishes,
Hans

iksotof
3StarLounger
Posts: 315
Joined: 04 May 2010, 15:18

Re: Word 2010

Post by iksotof »

Great idea that Hans

Thanks