#1   Report Post  
Herbert Stencil
 
Posts: n/a
Default Mail Merging a Table

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   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
changing proportion of chart and data table Dawn Parks Charts and Charting in Excel 3 January 6th 05 01:18 AM
Extract Data for Mail Merge Rashid Khan Excel Discussion (Misc queries) 7 December 24th 04 05:47 PM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 11:56 AM
How to create a calculated field formula based on Pivot Table resu dha17 Excel Discussion (Misc queries) 1 December 15th 04 05:39 AM
Data Table - Does it work with DDE links and stock tickers? Post Tenebras Lux Excel Discussion (Misc queries) 0 December 1st 04 05:15 PM


All times are GMT +1. The time now is 04:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"