lesser-equity

Computer Juice Magazine
Go Back   Computer Juice > Computer Software > Office Suites & Applications



Reply
 
Thread Tools
  #1  
Old 19th Mar 2008, 12:17
New Member Group
 
Posts: 1
Default Word 2007 mail merge results question

I am creating a word document with multiple test criteria and am wondering how I would remove a space if the data is not shown. Here is my code-
1.{IF{mergefield cst_ela}="proficient""english cst: proficient"""}
2.{IF{mergefield cst_elb}="proficient""history cst: proficient"""}
3.{IF{mergefield cst_elc}="proficient""math cst: proficient"""}
4.{IF{mergefield cst_eld}="proficient""science cst: proficient"""}
The leading numbers are just for show here. So if 1 is true it shows up but if 2 is not true its blank and 3 could be true as well so the letter will have a blank line between 1 and 3. Is there a way to tell it if 2 is blank remove space?I hope this makes sense, any help would be greatly appreciated.

[SIZE=3][/SIZE]

  #2  
Old 9th May 2008, 23:49
Donor Group
 
Skill Level: Intermediate
Posts: 1,788
Default Word 2007 mail merge results question

if you were to list them out ie -
{IF{mergefield cst_ela}="proficient""english cst: proficient"""}{IF{mergefield cst_elb}="proficient""history cst: proficient"""}
rather than placing a lin between the actual code.. would this solve your problem?
__________________

My System: FordyPC

Processor(s):
Quad Q6600 Kentsfield @ 3.15GHz
Motherboard:
Asus P5Q/L PRO (Intel P43, ICH10)
RAM Memory:
PNY XLR8 4GB @ 1066MHz
Graphics Card(s):
PNY nVidia GeForce 9400 GT 512MB
Sound Card:
Hard Drive(s):
Seagate HDBarracuda 1x 1TB 1x 250GB
Optical Drive(s):
LG (HD)GGCH20L / LG GH22NP20AUAA50B
Case / PSU:
Antec Sonata III & Earthwatts 500W
Cooling:
Stock
Network / Internet:
Gigabit LAN, FireWire & WG111v2
Monitor(s):
2 x Acer P193WAD
Operating System(s):
XP PRO x86/XP PRO x64/Win7 RC1 x64
  #3  
Old 10th May 2008, 04:52
Moderator Group
 
Skill Level: Advanced
Posts: 2,893
Default Word 2007 mail merge results question

Have a look at these KB articles.

http://support.microsoft.com/kb/264892

http://support.microsoft.com/kb/116360

If you don't understand it I can try to help you more (I don't know much about these mailmerge statements though!.... I can learn)

Heres another good tutorial http://word.mvps.org/FAQs/MailMerge/MMergeIfFields.htm
__________________
serverguy

__________________

My System: Eclipse

Processor(s):
Intel C2D E7200 OC'd @ 3.6Ghz
Motherboard:
Asus P5Q Pro
RAM Memory:
OCZ 8GB 800Mhz
Graphics Card(s):
Saphire Radeon 4850
Sound Card:
Onboard
Hard Drive(s):
Vast
Optical Drive(s):
Sony al cheapo one.
Case / PSU:
Antec Three Hundred
Cooling:
Arctic Cooler 7 Pro, 3 case fans.
Network / Internet:
Titan ADSL
Monitor(s):
Dual 19" LCD
Operating System(s):
XP SP3

Please support this forum, donate towards our running costs.
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2007, Excluding pages from word count snowblind Office Suites & Applications 8 21st Mar 2009 12:27
Word 2007 Smart Art bug? rockyshred336699 Office Suites & Applications 0 18th Apr 2008 08:58
Word 2007 help robina80 Office Suites & Applications 2 21st Jan 2008 13:53
Merge outlook contact into word 2007.dot template RFgen Office Suites & Applications 1 19th Sep 2007 07:47
Word 2007 Maria Office Suites & Applications 3 10th Jun 2007 16:34

Tags
2007, mail, merge, question, results, word

Bookmarks
Thread Tools



Arabic Bulgarian Chinese (Simplified) Chinese (Traditional) Croatian Czech Danish Dutch English Finnish French German Greek Hebrew Hungarian Italian Japanese Korean Norwegian Polish Portuguese Romanian Russian Serbian Slovak Spanish Swedish Thai Turkish

Copyright ©2006 - 2009 Computer Juice.

Powered by vBulletin® Copyright ©2000 - 2009 Jelsoft Enterprises Ltd. SEO by vBSEO ©2009, Crawlability, Inc.