I have a pivot table and source sheet that I have moved from my original
workbook into a new workbook (thus only 2 sheets in the workbook). I need to
create a Word document that pulls information from one field in the pivot
table and also uses name, address, etc. fields from the source sheet. Is
that possible?

No, Word can using only a single flat file as a datasource.

--
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

"cjlatta" wrote in message
...
I have a pivot table and source sheet that I have moved from my original
workbook into a new workbook (thus only 2 sheets in the workbook). I need
to
create a Word document that pulls information from one field in the pivot
table and also uses name, address, etc. fields from the source sheet. Is
that possible?

That answers my question (not what I really wanted to find out, but it's the
answer I needed!)
Thanks!

"Doug Robbins - Word MVP" wrote:

No, Word can using only a single flat file as a datasource.

--
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

"cjlatta" wrote in message
...
I have a pivot table and source sheet that I have moved from my original
workbook into a new workbook (thus only 2 sheets in the workbook). I need
to
create a Word document that pulls information from one field in the pivot
table and also uses name, address, etc. fields from the source sheet. Is
that possible?