![]() |
#2
|
|||
|
|||
![]()
This isn't exactly a "link" but a simple mailmerge. What you want is an IF field.
This example shows a mergefield named Field1. It prints: Field 1: contents of field 1 on a separate line if, and only if, there are contents in field1. If field1 can be a negative number you would want the condition to be <> 0. Turn on display of field codes when writing fields. Alt-F9 This is what the fields will look like. Note the line break in the middle of the IF field which is actually a paragraph mark in Word. { IF { MERGEFIELD Field1 } > 0 "Field1: { MERGEFIELD Field1} " "" } Note the braces {} cannot be typed in from the keyboard. They have to be inserted by Word. They come in pairs. They are inserted when you add a merge field or a regular field. You can make your own fields with Ctrl-F9 which inserts a pair. ![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
External/Embedded links to excel | lucas | Word | 3 | 03-30-2012 01:47 PM |
Edits links to Excel file in PowerPoint | ziba | PowerPoint | 4 | 01-09-2012 08:48 AM |
Powerpoint 2010 losing links to excel | Hans_b | PowerPoint | 0 | 07-12-2011 04:19 AM |
Updating Excel Chart Links | fermat | PowerPoint | 0 | 07-09-2010 04:29 PM |
Break Links with Excel | streng | Word | 0 | 06-29-2009 02:43 AM |