View Single Post
  #3   Report Post  
Rob Cowlard
 
Posts: n/a
Default

Thanks for replying Peter but I am still unsure what to do
next. If you can give me a momoent I explain further what
I am doing and it might you understand my problem better.

My main Mail Merge(MM) doc is client specific letter and
prints on headed paper via a section break, the other two
MM docs which are personalised information sheets, are
used by all clients and print on plain. The data source
used by all three is MailMergeData.csv and this is created
on the fly in a user's temp directory each time they come
to do a MM. By always naming the csv the same I can have
the data source hard coded in for the two plain paper docs
and so keep them generic. So when a client specific main
doc is created pointing at MailMergeData.csv it correctly
shows and allows a user to toggle through the results
set. However, the two information sheets always show the
data for the first record now matter which one you are on
in the letter. The only way to view the information
sheets correctly is to double click on them from the main
docs and toggle them independantly which is obviously
pants!. As the column names of MailMergeData.csv never
change I was hoping for a way for the information sheets
to referenece this data as the main doc does.... If this
is what you thought my problem was and the includetext
response was the correct one then would you be so kind as
to explain it further so that I can implement it in my
code. PS - Although this is my first foray into using
Word from a development point of view as until now I had
always considered it as one of those apps that the users
use.

Cheers and thanks again

Rob
-----Original Message-----
1. There is only one mail merge data source per merge.

However you link in
your "subdocuments", they will not have separate data

sources from the main
document. However, this does not sound like the problem

in your case.

2. I think you need to include your documents using

INCLUDETEXT fields
rather than LINK or EMBED fields.

Peter Jamieson

"Rob Cowlard"

wrote in message
...
Afternoon all,

I am an application developer exporting data from a
database in the form of a csv and then performing a

number
of mail merges on it but I have a problem. I have set

up
and tested three mail merges independently against the
same source but when I link/embed two of them into my
first main mail merge doc they become static. So when I
go from record to record in the main doc the two
linked/embedded docs do follow along and remain showing
the data for the first person in my dataset. Is it
possible to have the two linked/embedded docs driven

from
the first?

If this sounds strange to you the reason that I am doing
the is that the first document is client specific but

the
other two are generic and so if can get this working the
maintenance overheads should be much lower.

Thanks in advance for any advice

Rob

Word version – 2002 SP2



.