Is there a way to merge a specific field from excel 2010 to word 2010?

Example:



In excel 2010 a spreadsheet is saved:

ID Name Age
1 Sam 19
2 Bob 25
3 Paul 27

In word 2010:
ID1 Name Age
ID2 Name Age
ID3 Name Age
Thanks.

It appears you're after a list, based on the ID, Name & Age of persons in your Excel workbook. A Word Directory/Catalog mailmerge can do this. It doesn't matter what other fields your Excel workbook has - the mailmerge wizard allows you to choose which fields to add to your output.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Is it possible to select 4 rows in the excel spreadsheet and populate 4 seperate rows in a word document? So the Block1 row in the excel would populate the Name Age in the word document. In the first colum and Block2 would populate Name Age in the next column of the word document? Thanks

By default, a mailmerge will process however many records you have. However, the mailmerge helper has a filtering option which allows you to choose particular records - or you can output the lot to a new file then delete the ones you're not interested in afterwards.

As you seem to be starting out, see:
http://support.microsoft.com/kb/826838
http://word.mvps.org/FAQs/MailMerge/index.htm

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]