Re: Mailmerge multiple query's

Are you trying to produce
a. 8 documents. Each document looks the same, but has the data from a
different query
b. 1 document, containing a table with the data from each query

Or something else?

If it makes it more simple to describe, make a sample doc to show
approximately
a. how you want the data to appear
b. where the data should come from
and e-mail it to me. You will need to despam my e-mail address by removing
the text "KillMaps".

Peter Jamieson


"Igor G." <IgorG@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FC63E874-07B7-4E75-90A9-A58A0BF8B385@xxxxxxxxxxxxxxxx
I have word template (formated table) with 8 columns and I want insert
fields
manualy to some cells in this table. This is usualy process list.

All query's get data from same table but for diferent product (example -
price field), and have diferent numbers of rows. I must separate products
and
put this in template.


"Peter Jamieson" wrote:

Can you describe a bit more about what you mean? For example:
a. Do all the queries return the same columns, and do you just want to
combine all the rows returned by all the queries into one big data source
for a single merge? Or
b. Do all the queries have the same number of rows, bu different
columns,
and you want to combine all the columns into one big data source for a
merge? Or
c. are the query results related in some other way? Or
d. do you want to perform one merge per query, but maybe you want to
automate the process.

Or what?

Peter Jamieson

"Igor G." <IgorG@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E47CF71D-C9B8-4C99-B3BB-B8F602DDAA98@xxxxxxxxxxxxxxxx
I want to mailmerge data from about 8 or more query's from Access.
How can I do this?

Thanks!





.

Relevant Pages

  • Re: Mail merge with Access DB does not see a query
    ... You can use a query as the data source, but certain types of query (e.g. ... this would work fine except for thin clients. ... >> most tables and queries. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: mail merge recipients
    ... checked records and use that Query as the data source. ... "Peter Jamieson" wrote: ... in the Mail Merge Recipients dialog box, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Mail Merge
    ... "Peter Jamieson" wrote: ... can you conect to any of the tables in your .mdb, or do you see the same ... when you are in Open Data Source, ... can see the listing of table and queries but when I select the query I ...
    (microsoft.public.word.mailmerge.fields)
  • RE: Dynamically referencing a recordset?
    ... through that recordset to set the query parameters in VBA. ... to be the one who had to modify 1440 queries if there is a change in the ... different table schema, then you need 3, one for each record type. ... This is a database that tracks the production on records in another ...
    (microsoft.public.access.modulesdaovba)
  • Re: Create a query based on user input
    ... I tried using append queries to ... main query and change the data source. ... queries and code where this one query is called from. ... So the user selects a drop down for the client they want informationfrom, ...
    (microsoft.public.access.formscoding)