Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

Geek Culture / Link word and excel

Author
Message
Phaelax
DBPro Master
15
Years of Service
User Offline
Joined: 16th Apr 2003
Location: Metropia
Posted: 2nd Sep 2015 16:45
Is there a way to have variables in Word but have their values pulled from an excel document? This could really speed up the time it takes to update 100+ memos.


"I like offending people, because I think people who get offended should be offended." - Linus Torvalds
Ortu
DBPro Master
10
Years of Service
User Offline
Joined: 21st Nov 2007
Location: Austin, TX
Posted: 2nd Sep 2015 17:50
template + mail merge might be able to do what you are looking for

i actually prefer to just write the documents directly in Excel though myself.

Kendor
15
Years of Service
User Offline
Joined: 31st Jan 2003
Location: Malta
Posted: 2nd Sep 2015 22:42
As Ortu said, it is a simple mail merge.

1. Create the document in Word.
2. Start a mail merge taking the excel as the source of data.
3. Set the mail merge fields as part of the Word document.
4. Proceed to generate the individual documents based on the excel variables.


Login to post a reply

Server time is: 2018-09-26 05:46:14
Your offset time is: 2018-09-26 05:46:14