NOT MAILING - want to merge data into a single doc from an Excel s

T

TCZynchros

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?
 
D

Doug Robbins - Word MVP

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/cindymeister/mergfaq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top