Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mail Merge from pivot table (Office 2000)
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? |
#2
|
|||
|
|||
Mail Merge from pivot table (Office 2000)
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? |
#3
|
|||
|
|||
Mail Merge from pivot table (Office 2000)
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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I do a conditional mail merge into a table | Mailmerge | |||
mail merge - Access 2000 and Word 2000 | Mailmerge | |||
Convert Table Labels to do Mail Merge? | Mailmerge | |||
Office 2003 mail merge mangle? | Mailmerge | |||
Mail Merge needs to return to 2000 format | New Users |