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" <(E-Mail Removed)> wrote in message
news:CEF7B7E1-42AC-49E3-BEAC-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:CEF7B7E1-42AC-49E3-BEAC-(E-Mail Removed)...
> > 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
> >
>