Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
homes747 homes747 is offline
external usenet poster
 
Posts: 4
Default Mail Merge Field Code Alternative

I know how to program field codes based on mail merge data, but I have a
problem in that text strings in field codes appear to be limited to a certain
number of characters (255 perhaps). Is there an alternative to simply typing
in the text you need in the field code itself?

For example, in an offer letter, if an employee is receiving relocation
assistance, they should receive two paragraphs of information (more then Word
will allow you to put in a field code text string). Is there any other way
to work the if/then in there, so I don't just have to delete the two
paragraphs for all individuals who aren't eligible.

Thanks,
Morgan
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail Merge Field Code Alternative

Use an INCLUDETEXT field.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"homes747" wrote in message
...
I know how to program field codes based on mail merge data, but I have a
problem in that text strings in field codes appear to be limited to a
certain
number of characters (255 perhaps). Is there an alternative to simply
typing
in the text you need in the field code itself?

For example, in an offer letter, if an employee is receiving relocation
assistance, they should receive two paragraphs of information (more then
Word
will allow you to put in a field code text string). Is there any other
way
to work the if/then in there, so I don't just have to delete the two
paragraphs for all individuals who aren't eligible.

Thanks,
Morgan



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Mail Merge Field Code Alternative

Use an includetext field or an autotext field to insert however much data
you like.
eg
{IF {Mergefield RelocationAssistance} = "True" "{IncludeText
"c:\\path\\docname.doc"}"}

--

Graham Mayor - Word MVP

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


homes747 wrote:
I know how to program field codes based on mail merge data, but I
have a problem in that text strings in field codes appear to be
limited to a certain number of characters (255 perhaps). Is there an
alternative to simply typing in the text you need in the field code
itself?

For example, in an offer letter, if an employee is receiving
relocation assistance, they should receive two paragraphs of
information (more then Word will allow you to put in a field code
text string). Is there any other way to work the if/then in there,
so I don't just have to delete the two paragraphs for all individuals
who aren't eligible.

Thanks,
Morgan



  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
homes747 homes747 is offline
external usenet poster
 
Posts: 4
Default Mail Merge Field Code Alternative

Graham,

Thanks for the tip, but I'm still having a little problem. In the example
below, I want the if statement to look up whether or not someone's STI Level
is blank. If it's not blank, then I want them to includetext. If it is
blank, then I want it to stay blank. Here's what I wrote:

{ IF { MERGEFIELD STILevel } "" "{ IncludeText
"\\Usrtnac02\hr-recruiting$\\HR Database\\Offer Data Text - Sign-on, Relo,
SIP, STI.doc" ShortTermIncentive }" "" }

However, it just displays the text MERGEFIELD. As you can see, I have
several text fields that I want this to work with housed in a single Word
document separated by bookmarks. Can you help?

Morgan

"Graham Mayor" wrote:

Use an includetext field or an autotext field to insert however much data
you like.
eg
{IF {Mergefield RelocationAssistance} = "True" "{IncludeText
"c:\\path\\docname.doc"}"}

--

Graham Mayor - Word MVP

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


homes747 wrote:
I know how to program field codes based on mail merge data, but I
have a problem in that text strings in field codes appear to be
limited to a certain number of characters (255 perhaps). Is there an
alternative to simply typing in the text you need in the field code
itself?

For example, in an offer letter, if an employee is receiving
relocation assistance, they should receive two paragraphs of
information (more then Word will allow you to put in a field code
text string). Is there any other way to work the if/then in there,
so I don't just have to delete the two paragraphs for all individuals
who aren't eligible.

Thanks,
Morgan




  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
homes747 homes747 is offline
external usenet poster
 
Posts: 4
Default Mail Merge Field Code Alternative

I figured out that I have to use Ctrl-F9 to place the brackets, but now I'm
getting a message that states "Error! Not a valid file name."

Any thoughts?

Morgan

"Graham Mayor" wrote:

Use an includetext field or an autotext field to insert however much data
you like.
eg
{IF {Mergefield RelocationAssistance} = "True" "{IncludeText
"c:\\path\\docname.doc"}"}

--

Graham Mayor - Word MVP

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


homes747 wrote:
I know how to program field codes based on mail merge data, but I
have a problem in that text strings in field codes appear to be
limited to a certain number of characters (255 perhaps). Is there an
alternative to simply typing in the text you need in the field code
itself?

For example, in an offer letter, if an employee is receiving
relocation assistance, they should receive two paragraphs of
information (more then Word will allow you to put in a field code
text string). Is there any other way to work the if/then in there,
so I don't just have to delete the two paragraphs for all individuals
who aren't eligible.

Thanks,
Morgan






  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail Merge Field Code Alternative

Did you use Ctrl+F9 to insert each pair of field delimiters { }? You cannot
just type them in using the keys that look like that on the keyboard.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"homes747" wrote in message
...
Graham,

Thanks for the tip, but I'm still having a little problem. In the example
below, I want the if statement to look up whether or not someone's STI
Level
is blank. If it's not blank, then I want them to includetext. If it is
blank, then I want it to stay blank. Here's what I wrote:

{ IF { MERGEFIELD STILevel } "" "{ IncludeText
"\\Usrtnac02\hr-recruiting$\\HR Database\\Offer Data Text - Sign-on, Relo,
SIP, STI.doc" ShortTermIncentive }" "" }

However, it just displays the text MERGEFIELD. As you can see, I have
several text fields that I want this to work with housed in a single Word
document separated by bookmarks. Can you help?

Morgan

"Graham Mayor" wrote:

Use an includetext field or an autotext field to insert however much data
you like.
eg
{IF {Mergefield RelocationAssistance} = "True" "{IncludeText
"c:\\path\\docname.doc"}"}

--

Graham Mayor - Word MVP

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


homes747 wrote:
I know how to program field codes based on mail merge data, but I
have a problem in that text strings in field codes appear to be
limited to a certain number of characters (255 perhaps). Is there an
alternative to simply typing in the text you need in the field code
itself?

For example, in an offer letter, if an employee is receiving
relocation assistance, they should receive two paragraphs of
information (more then Word will allow you to put in a field code
text string). Is there any other way to work the if/then in there,
so I don't just have to delete the two paragraphs for all individuals
who aren't eligible.

Thanks,
Morgan






  #7   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail Merge Field Code Alternative

Get you include text field working outside of the mailmerge environment. If
the error message still says that the filename is invalid, you will have to
do something to get a valid filename.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"homes747" wrote in message
...
I figured out that I have to use Ctrl-F9 to place the brackets, but now I'm
getting a message that states "Error! Not a valid file name."

Any thoughts?

Morgan

"Graham Mayor" wrote:

Use an includetext field or an autotext field to insert however much data
you like.
eg
{IF {Mergefield RelocationAssistance} = "True" "{IncludeText
"c:\\path\\docname.doc"}"}

--

Graham Mayor - Word MVP

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


homes747 wrote:
I know how to program field codes based on mail merge data, but I
have a problem in that text strings in field codes appear to be
limited to a certain number of characters (255 perhaps). Is there an
alternative to simply typing in the text you need in the field code
itself?

For example, in an offer letter, if an employee is receiving
relocation assistance, they should receive two paragraphs of
information (more then Word will allow you to put in a field code
text string). Is there any other way to work the if/then in there,
so I don't just have to delete the two paragraphs for all individuals
who aren't eligible.

Thanks,
Morgan






  #8   Report Post  
Posted to microsoft.public.word.mailmerge.fields
homes747 homes747 is offline
external usenet poster
 
Posts: 4
Default Mail Merge Field Code Alternative

Doug,

Thanks. It appears that the problem is the fact that I'm trying to "link"
to a document on a shared drive. When I did everything the same, but moved
the file to my C: drive, it worked fine.

I'll have to find another solution.

Morgan

"Doug Robbins - Word MVP" wrote:

Get you include text field working outside of the mailmerge environment. If
the error message still says that the filename is invalid, you will have to
do something to get a valid filename.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"homes747" wrote in message
...
I figured out that I have to use Ctrl-F9 to place the brackets, but now I'm
getting a message that states "Error! Not a valid file name."

Any thoughts?

Morgan

"Graham Mayor" wrote:

Use an includetext field or an autotext field to insert however much data
you like.
eg
{IF {Mergefield RelocationAssistance} = "True" "{IncludeText
"c:\\path\\docname.doc"}"}

--

Graham Mayor - Word MVP

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


homes747 wrote:
I know how to program field codes based on mail merge data, but I
have a problem in that text strings in field codes appear to be
limited to a certain number of characters (255 perhaps). Is there an
alternative to simply typing in the text you need in the field code
itself?

For example, in an offer letter, if an employee is receiving
relocation assistance, they should receive two paragraphs of
information (more then Word will allow you to put in a field code
text string). Is there any other way to work the if/then in there,
so I don't just have to delete the two paragraphs for all individuals
who aren't eligible.

Thanks,
Morgan






  #9   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail Merge Field Code Alternative

Not so much the shared drive as the way to which it is being referred.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"homes747" wrote in message
...
Doug,

Thanks. It appears that the problem is the fact that I'm trying to "link"
to a document on a shared drive. When I did everything the same, but
moved
the file to my C: drive, it worked fine.

I'll have to find another solution.

Morgan

"Doug Robbins - Word MVP" wrote:

Get you include text field working outside of the mailmerge environment.
If
the error message still says that the filename is invalid, you will have
to
do something to get a valid filename.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"homes747" wrote in message
...
I figured out that I have to use Ctrl-F9 to place the brackets, but now
I'm
getting a message that states "Error! Not a valid file name."

Any thoughts?

Morgan

"Graham Mayor" wrote:

Use an includetext field or an autotext field to insert however much
data
you like.
eg
{IF {Mergefield RelocationAssistance} = "True" "{IncludeText
"c:\\path\\docname.doc"}"}

--

Graham Mayor - Word MVP

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


homes747 wrote:
I know how to program field codes based on mail merge data, but I
have a problem in that text strings in field codes appear to be
limited to a certain number of characters (255 perhaps). Is there
an
alternative to simply typing in the text you need in the field code
itself?

For example, in an offer letter, if an employee is receiving
relocation assistance, they should receive two paragraphs of
information (more then Word will allow you to put in a field code
text string). Is there any other way to work the if/then in there,
so I don't just have to delete the two paragraphs for all
individuals
who aren't eligible.

Thanks,
Morgan








Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't get Word 2003 to keep data file with mail merge main documen Yourcareercoach Mailmerge 9 August 10th 06 12:19 PM
Field Codes disapearing During a mail merge Ernie Microsoft Word Help 2 April 28th 06 08:35 PM
Can Mail Merge include a space at the beginning of a field? Joshua Mailmerge 5 April 13th 06 06:37 AM
Form Letter Mail Merge using field code: {Database} jyan Mailmerge 8 December 19th 05 09:18 PM
Suppressing Merge Field and text before/after julie Microsoft Word Help 8 November 14th 05 02:50 PM


All times are GMT +1. The time now is 03:44 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"