[Doug Robbins - Word MVP]

If you use a Directory type mail merge main document in which you insert

Part No. StockCode¶
Description¶
Price Selling Price¶
¶

When you execute that merge to a new document, you will get

Part No. AF-070-083
Cultiva ATC Power Cable
Price 193

Part No. AF-110-0007-01
A5 Rover DUO
Price 29750

Part No. AF-110-0007-03
A5 Rover DUO
Price 0

Part No. AF-110-0009-01
A5 Rover QUAD
Price 34750

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Steve" wrote in message
...
Hi Doug,
The exteranl file contains data like this:

StockCode,Description,SellingPrice
AF-070-083,Cultiva ATC Power Cable,193
AF-110-0007-01,A5 Rover DUO,29750
AF-110-0007-03,A5 Rover DUO,0
AF-110-0009-01,A5 Rover QUAD,34750

That is the .csv file any way, the XML looks like this:

FormattedReportObjects
FormattedReportObject xsi:type="CTFormattedField" Type="xsd:string"
FieldName="{InvMaster.StockCode}"ObjectNameStoc kCode1/ObjectName
FormattedValueAF-070-083/FormattedValue
ValueAF-070-083/Value
/FormattedReportObject
FormattedReportObject xsi:type="CTFormattedField" Type="xsd:string"
FieldName="{InvMaster.Description}"ObjectNameDe scription1/ObjectName
FormattedValueCultiva ATC Power Cable/FormattedValue
ValueCultiva ATC Power Cable/Value
/FormattedReportObject
FormattedReportObject xsi:type="CTFormattedField" Type="xsd:string"
FieldName="{InvMaster.Supplier}"ObjectNameSuppl ier1/ObjectName
FormattedValueNOVA001/FormattedValue
ValueNOVA001/Value
/FormattedReportObject
FormattedReportObject xsi:type="CTFormattedField" Type="xsd:float"
FieldName="{InvMaster.MaterialCost}"ObjectNameM aterialCost1/ObjectName
FormattedValue84.18/FormattedValue
Value84.18/Value
/FormattedReportObject
FormattedReportObject xsi:type="CTFormattedField" Type="xsd:float"
FieldName="{InvPrice.SellingPrice}"ObjectNameSe llingPrice1/ObjectName
FormattedValue193.00/FormattedValue
Value193.00/Value
/FormattedReportObject
/FormattedReportObjects

with a few higher level objects ommited.

Thanks
Steve

"Doug Robbins - Word MVP" wrote:

How is the data arranged in the external file?
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Steve" wrote in message
...
Thanks for the replies. I don't think the directory mail merge will do
what
I need. The exteranl file contains more information than is required
and
is
not divided into the correct sections. I really need something that
will
search the exteranl file for a part no and get the associated
information.
The include text field may work, I will do some more reading.

Thanks
Steve

"Doug Robbins - Word MVP" wrote:

Why don't you use a Directory type mail merge?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Steve" wrote in message
...
Hi,
I am making a product catalouge for my company and I would like to
be
able
to automatically update the price and possibly product desrciption
from
an
external file, based on an entered product code. There would be a
layout
like this, with each part being in a new row, I would like the
sections
to be updated from the exteranl file (either .csv, .xls, or .xml).

Part No. XXXXXXXX
Auto Update Description for XXXXXXXX

Price Auto Update Price for XXXXXXXX

Part No. YYYYYYYY
Auto Update Description for YYYYYYYY

Price Auto Update Price for YYYYYYYY

Thanks in advance
Steve