Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I work for a church and I am trying to create a donation report for
2004. The data I have is in a CSV in the following format: Name, Date of Donation, Amount of Donation, Various Address Fields Does anyone have any suggestions on how I might perform a mail merge on this data so that all donations by one particular person will be listed in the same document? For example, if a particular person donated 5 times during the year I would like to create a document with the following list: Date1 Amount1 Date2 Amount2 Date3 Amount3 Thanks in advance for any guidance you can give me in how I can do something like this. Erich |
#2
![]() |
|||
|
|||
![]()
Word MVP, Cindy Meister, has extensive information about mail merge on
her web site: http://homepage.swissonline.ch/cindy...r/MergFram.htm Look under the heading 'Special Merges' for 'Multiple Items per Condition' Herbert Stencil wrote: I work for a church and I am trying to create a donation report for 2004. The data I have is in a CSV in the following format: Name, Date of Donation, Amount of Donation, Various Address Fields Does anyone have any suggestions on how I might perform a mail merge on this data so that all donations by one particular person will be listed in the same document? For example, if a particular person donated 5 times during the year I would like to create a document with the following list: Date1 Amount1 Date2 Amount2 Date3 Amount3 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
changing proportion of chart and data table | Charts and Charting in Excel | |||
Extract Data for Mail Merge | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) |