Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / July 2006

Tip: Looking for answers? Try searching our database.

Multiple ouputs from merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Smokey smith - 16 May 2005 07:29 GMT
My business deals with 4 different types of clients and I want to send a
different mailmerge letter to each client.

I have written a letter with some common text and the parts of the letter
that are different for each client type I have in separate bookmarks in
another document.

Each different type of client is identified by a field called <orgtype>.

The logic of the program is quite simple - a nested if statement.

My difficulty is as part of the true condition I insert {INCLUDETEXT "C:\\My
Documents\\[Business Name]\\Marketing\\clientdata.doc" [Bookmark]} and end up
with an invalid file name error.

HELP
Graham Mayor - 16 May 2005 08:57 GMT
It is difficult to troubleshoot a conditional field if you don't post the
whole code - and what are the bits in square brackets? Are they supposed to
be fields or are they simply to disguise a client? And what's the nesting
for?

The simplest plan would be to set either the bookmark names to match the
orgtype field content or to use orgtype to reflect the path. You don't need
the further complication of a conditional field.

e.g
{INCLUDETEXT "C:\\My Documents\\{mergefield
orgtype}\\Marketing\\clientdata.doc" Bookmarkname}
or
{INCLUDETEXT "C:\\My Documents\\Clientname\\Marketing\\clientdata.doc"
{Mergefield Orgtype}}

You will need to toggle the display to show the field result and update the
field before merging to a new document, or you will get a file or bookmark
error message (which you report that you are getting).

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

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

> My business deals with 4 different types of clients and I want to
> send a different mailmerge letter to each client.
[quoted text clipped - 13 lines]
>
> HELP
Smokey smith - 16 May 2005 23:51 GMT
Graham

Your assistance is greatly appreciated! I have changed the bookmark names
and ensure that they match with the names that are stored in the document and
still get the error.

Do you have any further ideas?

Peter

> It is difficult to troubleshoot a conditional field if you don't post the
> whole code - and what are the bits in square brackets? Are they supposed to
[quoted text clipped - 33 lines]
> >
> > HELP
Graham Mayor - 17 May 2005 06:23 GMT
Sorry, not at the moment.

I would ask you to post the document(s) but I am about to leave for the
airport as I am relocating to Cyprus today, and I may be off line for a
while as I will only have a poor dial-up connection to contend with until I
can get the local telecom company sorted out. Without looking at the exact
codes you are posting and what they are supposed to gather it is difficult
to spot where the error lies.

Test it by creating a document containing your standard texts. Mark the
standard texts as legitimate bookmarks and save that document. Then try
using the includetext without reference to mergefield to insert those texts
into a document. If that all works, broaden it out to selectively pick the
texts according to the merge data as originally suggested.

Until I am re-established, this is the best I can offer. Sorry :(

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

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

> Graham
>
[quoted text clipped - 53 lines]
>>>
>>> HELP
Smokey smith - 17 May 2005 07:09 GMT
Graham

Thank you for what you have done. I will implement your suggestions. Good
luck with the move.

Peter

> Sorry, not at the moment.
>
[quoted text clipped - 70 lines]
> >>>
> >>> HELP
Smokey smith - 16 May 2005 12:17 GMT
Graham

Thankyou for your response. I am sorry for not providing sufficient detail.

My business deals with schools (1); Kindergartens(2); Child Care centres(3);
and Age Care(4). Each of these businesses are identifed in a field called
"orgtype"

What I want is to be able to give a different letter for each client type
when I run the mail merge.

The Bookmarks are stored in a separate document.

As I said the logic of the program is quite simple:

{if {mergefield orgtype} = 1 {includetext"C:\\Business\\Marketing\\marketing
letter.doc" Schools} {if {mergefield orgtype} = 2
{includetext"C:\\Business\\Marketing\\marketing letter.doc" Kindergartens}{if
{mergefield orgtype} = 3 {includetext"C:\\Business\\Marketing\\marketing
letter.doc" Child Care Centres}
includetext"C:\\Business\\Marketing\\marketing letter.doc" Age Care}

Even after updating the field and toggling the field codes I still get the
error. I hope this extra information assists in understanding my issues.

Peter

> My business deals with 4 different types of clients and I want to send a
> different mailmerge letter to each client.
[quoted text clipped - 12 lines]
>
> HELP
Graham Mayor - 16 May 2005 17:24 GMT
The most obvious failing I can see is that you have illegal bookmark names.
You cannot name a bookmark with spaces.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

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

> Graham
>
[quoted text clipped - 44 lines]
>>
>> HELP
Ameobia - 26 Jul 2006 14:34 GMT
Here is what I did:

With that particular code,  I inserted an IF statement with the condition =
"youralphnumericvariable".  Next I put in the Includetext field and the file
path and name, with each particular code having it's own separate file.  
There were no bookmarks needed.  Granted there were several smaller files,
but the solution worked for me.

Ameobia

> The most obvious failing I can see is that you have illegal bookmark names.
> You cannot name a bookmark with spaces.
[quoted text clipped - 47 lines]
> >>
> >> HELP
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.