View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lalthan[_9_] lalthan[_9_] is offline
external usenet poster
 
Posts: 1
Default Importing excel values to word document


I have a word document (summary.doc)with a certain template and
information on the top (mainly summary) about a certain region.
When the summary part ends, I want to add some details of information
to the word file for that region eg. Name, Address, Age, Contact etc.
from another excel file which has all these datas (Employee code will
be the primary key to get all these datas to be imported into the word
file). The excel file is called data.xls. If the region has 5
employees, then all 5 employee detail should come in 5 lines (or
table), one line for each employee with the above details.

The Summary part has all the required texts already entered and it
occupies around 15 lines in the word sheet (summary.doc). After the
summary, I would like to write a macro which would add all the required
information to the word sheet from the excel sheet.

Any help on how to go about this with a macro would be appreciated.


--
lalthan
------------------------------------------------------------------------
lalthan's Profile: http://www.excelforum.com/member.php...o&userid=10557
View this thread: http://www.excelforum.com/showthread...hreadid=466286