Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Switch data from Excel to Word - Use as Mailing | Page Layout | |||
Updating Word mailing labels from Excel data | Microsoft Word Help | |||
Word 2003 Mail Merge Problem when E-Mailing Data Source | Mailmerge | |||
Importing separate rows of Excel data into single Word templates | Microsoft Word Help | |||
merge for a mass mailing (Excel)only recognizes first 820 recipien | Microsoft Word Help |