Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Megan Rytting Megan Rytting is offline
external usenet poster
 
Posts: 1
Default Merge from Excel Spread sheet to Word-- MULTIPLE ROWS per Word doc

I need to create a report in Word from a database of information that I have
created in Excel. However, there are several rows of information in excel on
each client. My question is- how do I merge all the information for one
client onto ONE word document. Right now, when I merge, it tries to have a
separate report for each row of information. Any ideas? Please???
  #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 Merge from Excel Spread sheet to Word-- MULTIPLE ROWS per Word doc

Sounds like you are probably trying to perform 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

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

"Megan Rytting" Megan wrote in message
...
I need to create a report in Word from a database of information that I
have
created in Excel. However, there are several rows of information in excel
on
each client. My question is- how do I merge all the information for one
client onto ONE word document. Right now, when I merge, it tries to have a
separate report for each row of information. Any ideas? Please???



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
Can you do a mail merge in reverse? word labels into excel spread JMc² Mailmerge 1 October 31st 06 05:32 AM
how to create labels from excel spread sheet drvi Microsoft Word Help 3 August 13th 06 04:31 AM
how do I reverse a mail merge from word back to an excel spread s strong Mailmerge 2 July 19th 06 09:13 AM
Excel spread sheet in Word Stan Microsoft Word Help 1 April 18th 05 10:37 PM
Merging excel 2003 spread sheet to word 2000 document Pat moore via OfficeKB.com New Users 1 February 18th 05 03:30 PM


All times are GMT +1. The time now is 11:37 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"