Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Goalie Girl Goalie Girl is offline
external usenet poster
 
Posts: 1
Default creating a statement of activity using Excel records

I need to create a statement of activity for families in our school. In
excel, I have multiple records for each family. Each record contains the
info for one purchase date and then all have multimple purchase dates. I am
good with doing mail merges when the data in one record is put on one page in
word. iIs there a way to tell word to pull all the records for one family
(multiple records in excel) and put them on one page in word. I would then
need to total some of the columns also. Are excel and word the best packages
to use for this or is access better?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default creating a statement of activity using Excel records

What you are trying to perform is a "multiple items per condition (=key
field)" mailmerge which Word does not really have the ability to do.

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at:

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic

Or take a look at the following Knowledge Base Article:

http://support.microsoft.com/default...b;en-us;211303

or at:

http://cornell.veplan.net/article.aspx?&a=3815

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Goalie Girl" Goalie wrote in message
...
I need to create a statement of activity for families in our school. In
excel, I have multiple records for each family. Each record contains the
info for one purchase date and then all have multimple purchase dates. I
am
good with doing mail merges when the data in one record is put on one page
in
word. iIs there a way to tell word to pull all the records for one family
(multiple records in excel) and put them on one page in word. I would
then
need to total some of the columns also. Are excel and word the best
packages
to use for this or is access better?



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
Creating a Customer Statement by merging Excel with Word Michael Hoeben Mailmerge 1 September 22nd 07 12:43 AM
merge records are using too many decimal spaces when I use records from an Excel Database aspen Mailmerge 1 March 23rd 07 10:12 PM
Logging Word Activity Uddhava Microsoft Word Help 4 September 10th 06 06:09 PM
Excel Records are selected but ALL blank records are merged creekmdm Mailmerge 2 April 26th 06 01:50 AM
Word & Outlook Activity Links Mike Microsoft Word Help 0 November 2nd 05 01:19 AM


All times are GMT +1. The time now is 07:38 PM.

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

About Us

"It's about Microsoft Word"