How can I do this without spending a million hours on it?

[Guest]

I am creating a evaluation booklet for a conference. What I need to do is
create an evaluation sheet for each speaker. Each evaluation will have the
same fixed content, but at the top of the page I need to import specific
information that I have in an excel
spreadsheet: name, title of presentation, etc.

Can anyone suggest a easy way to do this?

Thanks!

 

[Guest]

In Excel, you could set a dynamic range for each cell containing the
information.
In Word, create a link to each range name.
Your field should look something like:
{ LINK Excel.Sheet.8 "D:\\My Documents\\test1.xls" "Sheet1!MyName" \a
\t \u }

"Myname" being the dynamic range name

To get the braces, do ctrl-F9 and type between the braces Word gives you.

This was a solution Shauna provided me with back in January, and it worked a
treat.

Hope it helps,

 

[Doug Robbins - Word MVP]

Use Mail Merge

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[CyberTaz]

Why are you posting exactly the same issue as a separate issue with a
totally different subject?

Graham Mayor has been working with you on this in the "automating word
document" thread as recently as ~1 hour prior to this new post. Splitting
the conversation is not only unfair to those who waste their time answering
what's already been covered by others but also has broader ramifications &
makes it more difficult for you to track your responses.

Regards |:>)
Bob Jones
[MVP] Office:Mac