View Single Post
  #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 excel data to word 2007 table and text

From your description, it sounds like you may be doing a many to one type
mail merge.

For that, you might try the addin that I have created that you can obtain
from the following page of fellow MVP Graham Mayor’s website:

http://www.gmayor.com/ManyToOne.htm

Note however, that you will need to save the Excel spreadsheet in Excel
97-2003 format to be able to make use of that add-in
--
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, originally posted via msnews.microsoft.com

"David Gladstone" wrote in message
.. .
I am trying to create a learning plan that shows the route that a learner
might take to a qualification. The data are in an Excel 2007 worksheet.
The user data are NAME (C2), CENTRE (C3) COMPANY (C4) ENROLL DATE (C5)
The course data are in B7:E12 where the column B7:B12 contains the course
name, C7:C12 has the course code, D712 the start date and E7:E12 the end
date. Row 6 has column headings.
There will always be 3 rows of data but rows 10 to 12 may be blank.
The data are in the third sheet of an excel 2007 workbook
I am asking for help to merge these data to a word 2007 table. The
difficulties that I have experienced include pointing word to the 3rd
sheet
and taking data from rows 8 to 12

url:http://www.ureader.com/gp/1010-1.aspx