Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-28-2010, 07:44 AM
JennEx JennEx is offline Stumped With Mail Merge Formula Windows XP Stumped With Mail Merge Formula Office 2003
Competent Performer
Stumped With Mail Merge Formula
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default Stumped With Mail Merge Formula

I am extracting data for a mailmerge document from an excel database. One field of my report (a column ... B1 ... from the database) can be only one of three values ("Current Config.", a user entered value, or blank)



I have check boxes in my merge document that use a merge formula to populate.

Checkbox 1 ("Reline" is checked when B1 = "Current Config.", and Checkbox 2 is unchecked.

Checkbox 2 ("Changeover") is checked when B1 = any user entered value, and checkbox 1 is unchecked

If B1 = blank, or empty, both checkboxes are empty.

The merge formula I have established for Checkbox 1 is very straightforward:

Code:
{IF{MERGEFIELD R1RelineType}="Current Config." "1" "2"}
But I'm struggling over the logic behind the formula for checkbox 2 ... if basically needs to assign 1 when R1RelineType does not = "Current Config" or is not blank.

Can anyone provide any direction? I'm stumped.

Jenn
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stumped With Mail Merge Formula help with a mail merge akim281 Mail Merge 2 02-05-2010 02:54 PM
Help needed using the serial number date with sumifs - whole office is stumped FraserKitchell Excel 3 01-06-2010 12:24 PM
Mail Merge help dkwi04 Mail Merge 1 12-22-2009 11:23 PM
Mail Merge hiteshkataria Mail Merge 4 11-06-2009 05:11 AM
Word mail merge and formula mridley Mail Merge 0 04-30-2006 11:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:44 AM.


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