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