Suzanne
Thu Dec 30 10:41:09 CST 2004
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" <dkr@NOmvpsSPAM.org> wrote in message
news:umhO92l7EHA.2196@TK2MSFTNGP11.phx.gbl...
> 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/CreateAMailMerge.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" <ringotan@discussions.microsoft.com> wrote in message
> news:CEF7B7E1-42AC-49E3-BEAC-E8EE3AD6BD36@microsoft.com...
> > 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
> >
>