Mail Merge from pivot table (Office 2000)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cjlatta - 14 Nov 2005 17:21 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 14 Nov 2005 20:12 GMT

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

Signature

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

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

Reply to this Message

cjlatta - 14 Nov 2005 21:09 GMT

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

> No, Word can using only a single flat file as a datasource.
>
[quoted text clipped - 4 lines]
> > table and also uses name, address, etc. fields from the source sheet. Is
> > that possible?

Reply to this Message