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 / May 2005

Tip: Looking for answers? Try searching our database.

Embed fields in a separate source file?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
trf - 27 May 2005 21:53 GMT
I'm trying to create a "catalog" type mail merge document, but for 60 of the
~100 records, a sizable chunk of the text has already been written (and it
doesn't make sense to regenerate it using a new mail merge). I believe that I
need to use an IF field in conjunction with an INCLUDETEXT field:
{ IF {MERGEFIELD AlreadyWritten } = "Yes" "{ INCLUDETEXT c:\\xxx.doc }"
"<other text and fields>" }.

But, since there are 60 different versions of that text that's already been
written (a different version for each record), I can't just refer to one doc
in <xxx.doc>. What I'd like to do is set up all 60 of those already-written
chunks of text into one document, establish 60 bookmarks representing the
text that corresponds to each record, and then in the INCLUDETEXT field,
reference the range that corresponds to a specific record.

How do I do that? Is there a way outside VBA? If VBA is the only way, does
that mean that I might as well code the entire merge process (which will
involve a number of nested conditional statements anyway) into VBA rather
than using non-VBA mail merge fields?

Thanks!
Rob
trf - 27 May 2005 21:51 GMT
Oops -- I should have changed that subject line. I thought I was going to ask
a different question when I first typed it out. The subject should be more
like "Using ranges in INCLUDETEXT fields". Sorry about that -- for the
future, is there a way to remove a post (so I could repost with the right
subject)?

Rob

> I'm trying to create a "catalog" type mail merge document, but for 60 of the
> ~100 records, a sizable chunk of the text has already been written (and it
[quoted text clipped - 17 lines]
> Thanks!
> Rob
Graham Mayor - 28 May 2005 05:58 GMT
You cannot practically cancel a message - as messages are peered across a
variety of news servers over which you have no access rights, so ensure you
post what you intend or it will be recorded forever. You can change the
title in replies if that appeals, though frankly it doesn't help much here
:)

Much the easiest way to achieve this is to set an extra field in your data
source to indicate which of your 60 texts is relevant to that record. Then
you can use the information to ensure you merge the right bit of text. The
method is essentially that shown at
http://www.gmayor.com/mail_merge_graphics.htm albeit it is text you are
merging. You could save each text as a separate file to match your number,
or you could name the bookmarks to match the number. You then need only
insert the includetext field where either

{ Includetext "c:\\path\\{Mergefield number}.doc"}
or
{Includetext "c:\\path\\filename.doc" {mergefield number}}

should work

Signature

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

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

> Oops -- I should have changed that subject line. I thought I was
> going to ask a different question when I first typed it out. The
[quoted text clipped - 27 lines]
>> Thanks!
>> Rob

Rate this thread:






 
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.