Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Greg Greg is offline
external usenet poster
 
Posts: 113
Default Mailmerge data from a pivot table

The form letters I send get their information from a spreadsheet (not the
issue here). The information though comes from a one-tab spreadsheet which
itself is a copy of a pivot table in another spreadsheet. I copy the pivot
table tab from the original spreadsheet to another in order to copy/paste
values this new spreadsheet in order to break the link as a pivot table and
then remove the first 4 rows of the 'pivot table'. The spreadsheet can now
be used in a mailmerge. My question is - Is there an easier way to get
information from a pivot table into a mailmerged letter?

--
Greg
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Mailmerge data from a pivot table

Hi Greg,

You can probably achieve what you're after without the need for a pivot table (ie by using the worksheet containing the original
data), using filters and/or SKIPIF fields in the mailmerge main document.

--
Cheers
macropod
[Microsoft MVP - Word]


"Greg" wrote in message ...
The form letters I send get their information from a spreadsheet (not the
issue here). The information though comes from a one-tab spreadsheet which
itself is a copy of a pivot table in another spreadsheet. I copy the pivot
table tab from the original spreadsheet to another in order to copy/paste
values this new spreadsheet in order to break the link as a pivot table and
then remove the first 4 rows of the 'pivot table'. The spreadsheet can now
be used in a mailmerge. My question is - Is there an easier way to get
information from a pivot table into a mailmerged letter?

--
Greg


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
merging using pivot table data shedragon713 Mailmerge 1 July 7th 09 10:28 PM
using an excel pivot table as data for word mail merge Anne Mailmerge 1 September 30th 08 08:03 PM
Inverting a Table of Contents (similar to pivot table) [email protected] Formatting Long Documents 1 September 21st 06 10:27 PM
Mailmerge or Pivot Table? Tosca Mailmerge 3 June 17th 05 08:56 AM
Pivot Table ODBC marcmc Tables 1 April 24th 05 11:56 AM


All times are GMT +1. The time now is 05:52 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"