[pcor]

Ihave an Excel sheet with the following 6 headers(top of each col)
Name address phone 16 dec 23 dec 30 dec
Below is that various data
Smith 34 Water st 888 123 2345 10 20 5
the 10,20,5 are number representing donation for the dates above.
I know how to do the mail merge showing the name,address, phone and the 10
20 and 5
what I really want to do is as follows

Smith
34 Waters
888 123 2345
16 dec 10
23 dec 20
30 dec 5

How do I show that DATES
Thanks

[CyberTaz]

Your problem is that the dates have been used as field names (headers)
rather than as data. Although it may be possible to get the field names
brought in as a part of the merge it would take code to do it - there is no
"built-in" feature to include the names of the fields and I have no idea
what the code might be.

The easiest thing would be to just type the labeling into the main doc just
as though they were To/From/Regarding labels in a memo you were merging to.
In this case you would precede the data fields with typed labels such as 16
Dec: [field], 23 Dec: [field], , etc.

--
HTH |:)
Bob Jones
[MVP] Office:Mac

"pcor" wrote in message
...
Ihave an Excel sheet with the following 6 headers(top of each col)
Name address phone 16 dec 23 dec 30 dec
Below is that various data
Smith 34 Water st 888 123 2345 10 20 5
the 10,20,5 are number representing donation for the dates above.
I know how to do the mail merge showing the name,address, phone and the 10
20 and 5
what I really want to do is as follows

Smith
34 Waters
888 123 2345
16 dec 10
23 dec 20
30 dec 5

How do I show that DATES
Thanks

[Graham Mayor]

If I understand you correctly then you would need

{Mergefield Name}
{Mergefield address}
{Mergefield phone}
16 Dec {Mergefield "16 dec"}
23 Dec (Mergefield "23 dec"}
30 Dec {Mergefield "30 dec"}

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


pcor wrote:
Ihave an Excel sheet with the following 6 headers(top of each col)
Name address phone 16 dec 23 dec 30 dec
Below is that various data
Smith 34 Water st 888 123 2345 10 20 5
the 10,20,5 are number representing donation for the dates above.
I know how to do the mail merge showing the name,address, phone and
the 10 20 and 5
what I really want to do is as follows

Smith
34 Waters
888 123 2345
16 dec 10
23 dec 20
30 dec 5

How do I show that DATES
Thanks