Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Dorian C. Chalom Dorian C. Chalom is offline
external usenet poster
 
Posts: 15
Default Merge Checkbox conditional

How do I do a mail merge de/selecting a check box based on the value of a
field in the excel file?


  #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 Merge Checkbox conditional

Use an

{ IF { MERGEFIELD fieldname } = somevalue trueresult falseresult }

and in place of trueresult and falseresult in the above construction insert
the desired wingdings symbol, 254 for checked and 168 for unchecked.

You must use Ctrl+F9 to insert each pair of field delimiters in the above
and Alt+F9 to toggle of the display of the field codes. You may need to
update the fields (F9) in the resulting document to see the desired result.

--
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
"Dorian C. Chalom" wrote in message
...
How do I do a mail merge de/selecting a check box based on the value of a
field in the excel file?


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
mail merge with checkbox ram Mailmerge 1 June 5th 09 11:37 PM
Merge from Access checkbox 904allen Mailmerge 2 March 8th 08 04:32 PM
conditional checkbox?? Iragalam Microsoft Word Help 2 June 20th 07 10:19 PM
using conditional merge, how do I not merge blank records... sonia2080 Mailmerge 1 June 22nd 06 01:49 PM
Insert Merge Files within conditional merge rwav1 Mailmerge 1 May 25th 05 03:32 PM


All times are GMT +1. The time now is 11:10 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"