Hi,

I am trying to create a new ms words document with hard-coded text from an
existing ms excel spreadsheet containing data. I have an existing excel
spreadsheet say "data.xls" with 6 fields containing some records.

DATE COMPANY NAME ITEM1 ITEM2 ITEM3 QUOTED PRICE
------- ------------------ ------- ------- --------
------------------
12 apr abc limited xxxxxx xxxxxxx xxxxxxx $1234.56
11 dec xyz inc. xxxxxx xxxxxxx xxxxxxx $9999.99

I am trying to automate the entire quotation process like picking the data
of each record from the 6 fields and create a new ms words document with
hard-coded text and placed those data from the 6 fields from excel.

Thank you.



Ringo

You can use mailmerge for this. You will however have to remove the space
between COMPANY and NAME and between QUOTED and PRICE, as the mergefield
names cannot contain spaces.

See the article €œHow to create a Mail Merge€� at:

http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
"ringo tan" wrote in message
...
Hi,

I am trying to create a new ms words document with hard-coded text from an
existing ms excel spreadsheet containing data. I have an existing excel
spreadsheet say "data.xls" with 6 fields containing some records.

DATE COMPANY NAME ITEM1 ITEM2 ITEM3 QUOTED PRICE
------- ------------------ ------- ------- --------
------------------
12 apr abc limited xxxxxx xxxxxxx xxxxxxx
$1234.56
11 dec xyz inc. xxxxxx xxxxxxx xxxxxxx
$9999.99

I am trying to automate the entire quotation process like picking the data
of each record from the 6 fields and create a new ms words document with
hard-coded text and placed those data from the 6 fields from excel.

Thank you.



Ringo

Actually, Word won't make a problem about the spaces; it will replace them
with an underline. But if you prefer not to have an underline, you can close
up the spaces.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Doug Robbins - Word MVP" wrote in message
...
You can use mailmerge for this. You will however have to remove the space
between COMPANY and NAME and between QUOTED and PRICE, as the mergefield
names cannot contain spaces.

See the article €œHow to create a Mail Merge€� at:

http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
"ringo tan" wrote in message
...
Hi,

I am trying to create a new ms words document with hard-coded text from
an
existing ms excel spreadsheet containing data. I have an existing excel
spreadsheet say "data.xls" with 6 fields containing some records.

DATE COMPANY NAME ITEM1 ITEM2 ITEM3 QUOTED PRICE
------- ------------------ ------- ------- --------
------------------
12 apr abc limited xxxxxx xxxxxxx xxxxxxx
$1234.56
11 dec xyz inc. xxxxxx xxxxxxx xxxxxxx
$9999.99

I am trying to automate the entire quotation process like picking the
data
of each record from the 6 fields and create a new ms words document with
hard-coded text and placed those data from the 6 fields from excel.

Thank you.



Ringo