 |
 | 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 / February 2006MERGEFIELDS
Hello all, When I do a mail merge with VB, I am trying to update a certain value on my word document... It is using an IF field... But on the new merged document it just appears blank with no value { IF{MERGEFIELD PowerConnected } = 1 "Note: Power was connected at time of inspection." "Note: Power was not connected at time of inspection." } In the data I am passing PowerConnected does equal 1 ... is there anything you could suggest.... thanks Nathan Most likely the fields in the document need to be updated.  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 > Hello all, > [quoted text clipped - 11 lines] > > Nathan Don't know that it matters, but you need a space after IF. SignatureCharles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. > Hello all, > [quoted text clipped - 11 lines] > > Nathan This should work as you have it. If you merge the document with {Mergefield PowerConnected} what result do you get, when you think you should be getting "1"? Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hello all, > [quoted text clipped - 11 lines] > > Nathan Graham, I do get the value 1 if I just have that mergefield in the doc.... the problme is I need to use IF statements to display the applicable thing based on the value.... I dont get any format errors... But just no value appears when useing the if statement... im not sure what to do.... > This should work as you have it. If you merge the document with > {Mergefield PowerConnected} [quoted text clipped - 15 lines] >> >> Nathan In that case I have been unable to reproduce the problem here. I have no idea why this is not working if you have given us all the pertinent information. Have you tried it without your macro, by using the field construction in a merge document and attaching your data file? If that works, it would suggest that there is a problem with your vba coding. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Graham, > [quoted text clipped - 32 lines] >>> >>> Nathan i have an update on this when putting this into my document { IF {MERGEFIELD PowerConnected } = 1 "Note: Power was connected at time of inspection." "Note: Power was not connected at time of inspection." \* MERGEFORMAT } The value that gets printed when I do a mail merge is "PowerConnected" the actual merge value (i have checked this) is 1. > Most likely the fields in the document need to be updated. when and how do I update these fields... before or after the merge?? thanks nathan > Hello all, > [quoted text clipped - 11 lines] > > Nathan Was the If field constructed using Ctrl+F9 to insert the field delimiters? 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 >i have an update on this > [quoted text clipped - 29 lines] >> >> Nathan it was used by inserting the field... (in the Insert menu) and then select the IF field option... > Was the If field constructed using Ctrl+F9 to insert the field delimiters? > [quoted text clipped - 31 lines] >>> >>> Nathan got it sorted > it was used by inserting the field... (in the Insert menu) and then select > the IF field option... [quoted text clipped - 36 lines] >>>> >>>> Nathan |
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.