Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
TCZynchros TCZynchros is offline
external usenet poster
 
Posts: 1
Default NOT MAILING - want to merge data into a single doc from an Excel s

How do I get around the inane "recipient" restrictions in Word to just do a
pure merge of data from an Excel spreadsheet into a Word doc with
mergefields? 2007 is making me crazy because it won't let you do anything
but a mail merge and I am trying to create a SINGLE document with multiple
mergefields and multiple records per field that will display all data in the
same document. I have set up an Excel spreadsheet with all of my mergefield
names as headers and all of the relevant data in the column beneath the
appropriate header. I have set up my Word doc with the mergefields and Next
record indicators in tables where I know I have more than one value per
mergefield. How do I get Word to stop trying to create multiple docs with
the merge data?
  #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 NOT MAILING - want to merge data into a single doc from an Excel s

you are trying to perform a "multiple items per condition (=key
field)" mailmerge which, "out of the box", 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

"TCZynchros" wrote in message
...
How do I get around the inane "recipient" restrictions in Word to just do
a
pure merge of data from an Excel spreadsheet into a Word doc with
mergefields? 2007 is making me crazy because it won't let you do anything
but a mail merge and I am trying to create a SINGLE document with multiple
mergefields and multiple records per field that will display all data in
the
same document. I have set up an Excel spreadsheet with all of my
mergefield
names as headers and all of the relevant data in the column beneath the
appropriate header. I have set up my Word doc with the mergefields and
Next
record indicators in tables where I know I have more than one value per
mergefield. How do I get Word to stop trying to create multiple docs with
the merge data?



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
Switch data from Excel to Word - Use as Mailing Gazebo Page Layout 1 August 23rd 07 05:10 PM
Updating Word mailing labels from Excel data DL, Wisconsin Microsoft Word Help 5 July 23rd 07 09:18 PM
Word 2003 Mail Merge Problem when E-Mailing Data Source Karen Townsend Mailmerge 3 June 20th 06 08:21 AM
Importing separate rows of Excel data into single Word templates bardo Microsoft Word Help 1 January 24th 06 07:00 PM
merge for a mass mailing (Excel)only recognizes first 820 recipien Larry Microsoft Word Help 2 June 20th 05 02:58 AM


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