[Peter Jamieson]

Doug

Thanks for the heads-up

Peter
"Doug Robbins - Word MVP" wrote in message
...
The OP sent me the document and a datasource in the form of an Excel
spreadsheet, though he mentioned that was not the original data source.
The part of the document into which he was trying to merge the data
contained a table with a product in each cell and an If...then...Else...
mergefield that was intended to insert the quantity for the product in
that cell, if the product code in the record matched that of the product
in the cell.

I have sent him the following reply:

"IF the records in your data source were in the same order as the items in
respect of which you want to insert the quantities, (which they are NOT),
and, you had a record in the data source for each item (which you do NOT),
then you could use a Next Record field before each item (except the
first).



I note however that the document is not fully developed and I suspect that
what you are going to end up wanting to do is create a series of documents
in which each document contains the order of possibly multiple items for a
single client.



Quite frankly, Mail Merge is not really the best tool for that. The best
way to do it will depend on what is the real data source."



--
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

"Peter Jamieson" wrote in message
...
Like Doug, I can't quite visualize this.

It sounds like you're starting from a pre-defined page with a known set
of products. Does that mean that you have a catalog consisting of (say)
hundreds of pages, that each page is in a separate file, and that you are
doing a merge for each page?

If it's something like that, maybe you don't need a merge and could use
{ DATABASE } fields instead (it depends partly on your data source).

e.g. for an Access database, use something along the following lines for
each product

{ DATABASE \d "c:\\mydbs\\mydb.mdb" \s "SELECT prod_qty FROM [products]
WHERE [products].[prod_code] = 'Product1' \#0 }

Peter Jamieson

"Scruft" wrote in message
...
Hi Guys,

Thanks for the quick responses. Unfortunately my situation isn't as
simple
as I made it sound. The document I have is a page full of pictures and
descriptions of many of the products we sell. Each one has a small
section
for the qty ordered to be shown - this is my merge field.

Because there are many products on the page, and the source of the data
is
dynamic (hence I can't predict what order the products will be listed
in) I
have used an {IF} statement to match the product code in the data source
with
the code of the product on the page, eg:
{IF {MERGEFIELD prod_code} = "Product1" "{MERGEFIELD prod_qty}" ""}

This works perfectly, it brings across the right quantities and it's all
perfect. Only problem is that I get a new page for every product that's
in
the source data - I want them all on the one page.

Does this shed any light on the situation?

Thanks.

"Graham Mayor" wrote:

Change the merge document type from letter to directory/catalog.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Scruft wrote:
Hello,

I have a one-page document that uses a source with multiple records,
but I want the results all to be shown on the one document when it's
merged, rather than a new page for every record.

Does anyone have a suggestion on doing this?

Thanks.