Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't get Word 2003 to keep data file with mail merge main documen | Mailmerge | |||
Field Codes disapearing During a mail merge | Microsoft Word Help | |||
Can Mail Merge include a space at the beginning of a field? | Mailmerge | |||
Form Letter Mail Merge using field code: {Database} | Mailmerge | |||
Suppressing Merge Field and text before/after | Microsoft Word Help |