EXCEL 2 WORD

[Elliot]

I have a spreadsheet set up in a table format with several
column with headings.

I then have hundreds of rows of data.

Is it possible to set up a word document that I can
transfer each row into a different word document.

i.e a word document that contains the same heading except
rather than across the way the headings are set apart in a
formal fashion in the word document and I can then just
set up a link or something similar so it imports only the
data i need it to import

hope that makes sense??

 

[Paul]

I have a spreadsheet set up in a table format with several
column with headings.

I then have hundreds of rows of data.

Is it possible to set up a word document that I can
transfer each row into a different word document.

i.e a word document that contains the same heading except
rather than across the way the headings are set apart in a
formal fashion in the word document and I can then just
set up a link or something similar so it imports only the
data i need it to import

hope that makes sense??

You need to look at Mail Merge in Word.
Yours is a very similar requirement to that of getting many letters
addressed to different people whose names and addresses are in an Excel
file. You will put the MergeField names in a table in the Word document.

 

[Dave Peterson]

For your reading pleasure:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.