Need help linking Word & Excel documents

[claire]

My boss has has employee HR forms already made in Word. She wants to be able to enter certain information in one doc/file and have it automatically enter the info onto to other Word docs (such as SSN #, Last name, First, Address etc.). Can I do this using Excel and Word or should I use another program? Any suggestions are greatly appreciated.

 

[Jezebel]

You're asking the wrong question. Word and Excel are both well powerful
enough for the purpose. The tricky part is actually sorting out the
functionality you're after. What does 'automatically' mean here? You enter
data in one document: then what happens? How does Word (or whatever) know
which other documents you want? Why are you considering Excel? -- do you
need to do other than create documents?

Stop and plan your app very carefully. The rule of thumb in software is that
every hour you spend on design saves you ten hours of coding.

My boss has has employee HR forms already made in Word. She wants to be

able to enter certain information in one doc/file and have it automatically
enter the info onto to other Word docs (such as SSN #, Last name, First,
Address etc.). Can I do this using Excel and Word or should I use another
program? Any suggestions are greatly appreciated.

 

[macropod]

Hi Claire,

Depending on what you're trying to achieve, you could use Excel as a
mailmerge source for a Word document, or you could have Word link to or
embed portions of an Excel workbook.

Cheers

My boss has has employee HR forms already made in Word. She wants to be

able to enter certain information in one doc/file and have it automatically
enter the info onto to other Word docs (such as SSN #, Last name, First,
Address etc.). Can I do this using Excel and Word or should I use another
program? Any suggestions are greatly appreciated.