Go Back   Computer Juice > Computer Software > Office Suites & Applications
Register Members New Posts Donate Unanswered Posts Site Spy Search


Reply
 
Thread Tools
  #1  
Old 19-03-2008, 07:17 PM
No Avatar
neal540  United States
CJ New Member
 
neal540 is offline
 
Join Date: Mar 2008
Last Online: 19-03-2008 07:18 PM
Posts: 1
iTrader: (0)
neal540 is on a distinguished road
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]
Digg this postDel.icio.us this postTechnorati this postNetscape this postStumble this post
Reply With Quote
  #2  
Old 10-05-2008, 06:49 AM
4D(Fordy(Ford) Ollie's Avatar
CJ Donator
AMD Nvidia
4D(Fordy(Ford) Ollie is offline
Send a message via MSN to 4D(Fordy(Ford) Ollie Send a message via Skype™ to 4D(Fordy(Ford) Ollie
 
Join Date: Aug 2007
Last Online: Yesterday 01:11 PM
Posts: 277
iTrader: (0)
4D(Fordy(Ford) Ollie will become famous soon enough4D(Fordy(Ford) Ollie will become famous soon enough4D(Fordy(Ford) Ollie will become famous soon enough
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

CPU(s):
AMD Athlon 64 X2 Dual Core 3800+
Motherboard:
RAM:
1GB
Graphics Card(s):
nVidia GeForce 8300 GS
Sound Card:
Dell 7.1 HD Sound
Hard Drive(s):
250GB SATA
Optical Drive(s):
CDRW/DVDRW + LG BluRay, HDDVD, DVD Drive
Case / PSU:
Inspiron 531
Cooling:
British Summer
Network / Internet:
802.11a wireless broadband
Monitor(s):
Dell 19" TrueLife & Sony Bravia 26" Wide
Operating System(s):
Vista Home Premium 32-bit

Want your system info in your signature?

Last edited by 4D(Fordy(Ford) Ollie : 10-05-2008 at 06:50 AM. Reason: hadnt finished and i pressed finish! haha
Digg this postDel.icio.us this postTechnorati this postNetscape this postStumble this post
Reply With Quote
  #3  
Old 10-05-2008, 11:52 AM
serverguy's Avatar
CJ Donator
Intel ATi
serverguy is offline
 
Join Date: Nov 2007
Last Online: Yesterday 10:23 PM
Posts: 1,639
iTrader: (0)
serverguy is on a distinguished roadserverguy is on a distinguished road
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




Last edited by serverguy : 10-05-2008 at 12:06 PM.
Digg this postDel.icio.us this postTechnorati this postNetscape this postStumble this post
Reply With Quote

Please support this forum, donate towards our running costs.


Reply


Thread Tools

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2007 Smart Art bug? rockyshred336699 Office Suites & Applications 0 18-04-2008 03:58 PM
Word 2007, Excluding pages from word count snowblind Office Suites & Applications 1 17-04-2008 06:44 PM
word 2007 help robina80 Office Suites & Applications 2 21-01-2008 08:53 PM
Merge outlook contact into word 2007.dot template RFgen Office Suites & Applications 1 19-09-2007 02:47 PM
Word 2007 Maria Office Suites & Applications 3 10-06-2007 11:34 PM


Copyright ©2006 - 2008 Computer Juice.

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

Page copy protected against web site content infringement by Copyscape