 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / March 2008Merge from Access checkbox
the merge from Access has a feild with either a 1 or 0 as a value i need to have a check box on thr template that if the value is 1 the box is checed if 0 the box is not checked. i've serach but could find no help Use an If...then...Else field in the Word mailmerge main document that checks for the value supplied by Access and inserts the appropriate symbol depending upon the value { IF { MERGEFIELD fieldname } = 1 [insert symbol of checked box Wingdings 254 here] [insert symbol of unchecked box Wingdings 168 here] } Note you must use Ctrl+F9 to insert the field delimiters { } and replace the square brackets in the above and the text inside them with the symbols mentioned.  SignatureHope 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 > the merge from Access has a feild with either a 1 or 0 as a value i need > to > have a check box on thr template that if the value is 1 the box is checed > if > 0 the box is not checked. i've serach but could find no help thank you > the merge from Access has a feild with either a 1 or 0 as a value i need to > have a check box on thr template that if the value is 1 the box is checed if > 0 the box is not checked. i've serach but could find no help
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.