Hi all,

I need your kind guidance on how to create a new microsoft words document
using an existing excel spreadsheet? At present, I have an excel spreadsheet,
say "data.xls" containing data for example 6 fields such as COMPANY NAME,
DATE, ITEM1, ITEM2, ITEM,3 & QUOTATION TOTAL. Under these 6 fields are some
records of my customers.

COMPANY NM         DATE        ITEM1       ITEM2       ITEM3     QUOTATION
TTL  
----------------        -------       --------       -------       --------  
 -------------------
ABC Limited            3 Apr        xxxxx         xxxxx         xxxxxx    
$1234.56
AAA Inc.                 9 Dec       xxxxxx       xxxxxx       xxxxxxx    
$987.65    
BBB Consultations   11 Nov       xxxxx        xxxxx          xxxxxx    
$999.99

I am trying to automate this quotation process of creating a new words
document with hard coded texts at specific alignments and dump in the data
from these 6 fields every time I add a new record to ms excel. So I could
print out and fax to my customer the quotation document after trigger the
create new words docu macros.

Please enlighten me the workaround. Thank you.

Ringo