Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 04-20-2012, 02:23 PM
Charles Kenyon Charles Kenyon is offline Advanced Question about Links to Excel Windows Vista Advanced Question about Links to Excel Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,533
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

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.
Reply With Quote
 



Similar Threads
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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft