Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
MaxArk[_28_] MaxArk[_28_] is offline
external usenet poster
 
Posts: 1
Default Mail Merge Formula - Logic Stumped


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




--
MaxArk
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail Merge Formula - Logic Stumped

The following will return 1 if R1RelineType = "Current Config." or is blank
and 2 if it is anything else.

{IF{MERGEFIELD R1RelineType}="Current Config." "1" { IF { MERGEFIELD
R1RelineType } = "" "1" "2" } }



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"MaxArk" wrote in message
...

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




--
MaxArk


  #3   Report Post  
Abraham12 Abraham12 is offline
Junior Member
 
Posts: 3
Default

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:
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
find and replace with logic viensdansmavie Microsoft Word Help 7 September 22nd 09 12:58 PM
Merge Logic Functions joe925c New Users 3 February 8th 09 12:00 PM
Word file won't open - stumped Jamie Microsoft Word Help 3 January 13th 09 07:06 AM
If Then Else with mail merge faulty logic? [email protected] Mailmerge 1 September 11th 07 06:58 PM
Check Box Logic Eleanor Mailmerge 1 September 22nd 05 09:40 PM


All times are GMT +1. The time now is 12:19 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"