A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Mailmerge
Site Map Home Authors List Search Today's Posts Mark Forums Read Web Partners

mail merge doc with further linked/embedded mail merge docs not playing the game



 
 
Thread Tools Display Modes
  #1  
Old January 7th 05, 01:23 PM
Rob Cowlard
external usenet poster
 
Posts: n/a
Default mail merge doc with further linked/embedded mail merge docs not playing the game

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

Ads
  #2  
Old January 7th 05, 03:04 PM
Peter Jamieson
external usenet poster
 
Posts: n/a
Default

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



  #3  
Old January 7th 05, 05:23 PM
Rob Cowlard
external usenet poster
 
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



.

  #4  
Old January 8th 05, 10:15 AM
Peter Jamieson
external usenet poster
 
Posts: n/a
Default

OK, I'm still not sure whether the INCLUDETEXT approach will work, but it is
probably worth having a go. The general idea is:
a. your client letter is the only one that needs to have the data source
attached.
b. you insert an INCLUDETEXT field for each information sheet document,
e.g.

{ INCLUDETEXT "c:\\infosheets\\sheet1.doc" }
{ INCLUDETEXT "c:\\infosheets\\sheet2.doc" }

All this does is, in effect, include the contents of sheet1.doc and
sheet2.doc in the client letter. The effect is that the user sees no links,
just the complete text, and whatever merge record is being previewed should
be reflected in all parts of the text. However, I am not sure off the top of
my head whether you will be able to arrange the sections of the complete
document so that each part of the document is printed in the correct place,
and so that you get the right headers/footers printed. At the very least you
will need to ensure that the different documents do not use the same
paragraph styles in different ways.

If that can't be made to work, I suspect it will be difficult to solve this
problem in Word because you will, I think, end up needing to coordinate the
handling of three separate documents.

Peter Jamieson

"Rob Cowlard" wrote in message
...
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



.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 02:55 AM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Word-Excel 2003 - Mail Merge Recipients problem AYager Mailmerge 2 January 11th 05 05:11 AM
Mail merge toolbar unavailable after SP3 R Scott Lowden Mailmerge 1 December 1st 04 07:24 PM
Using Hyperlinks in Mail Merge IF...THEN...ELSE Statements Mark V Mailmerge 8 November 30th 04 02:31 PM


All times are GMT +1. The time now is 03:50 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.