Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail merge help required
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 |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail merge help required
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 |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail merge help required
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail-Merge: Can we have master detail relationship or multiple entities in word Mail-Merge? | Microsoft Word Help | |||
Help required ??? | Microsoft Word Help | |||
Advice for newbies VBA required mail merges | Mailmerge | |||
Attempted mail merge. Got this: A required file, "SCHDMAPI.DLL". | Mailmerge | |||
mail merge doc with further linked/embedded mail merge docs not playing the game | Mailmerge |