 |
 | 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 / April 2006If field code = "*" then paragraph changes
I am trying to make a mail merge letter that looks at a specified mergefield and returns specified text based on the field. For example: If field code is "lead" then test is "thank you for interest" If field code is "prospect" then text is "thank you for your application" If field code is "client" then text is "thank you for business" Is something like this possible { IF "{ MERGEFIELD myfield }" = "lead" "thank you for (your) interest" "{ IF "{ MERGEFIELD myfield }" = "prospect" "thank you for your application" "thank you for (your) business" }" } All the {} must be the special field codes you can insert using ctrl-F9. Peter Jamieson >I am trying to make a mail merge letter that looks at a specified >mergefield [quoted text clipped - 7 lines] > > Is something like this possible { IF "{ MERGEFIELD type }" = "lead" "Thank you for your interest." "" } Look up IF field in help. The braces cannot be typed in. You have to use Ctrl-F9 or Insert > Field.  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! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. >I am trying to make a mail merge letter that looks at a specified >mergefield [quoted text clipped - 7 lines] > > Is something like this possible What about doing this with idea with and entire letter. Anotherwords, if "lead" then the letter (2 - 3 paragraphs and maybe even a table will return. and if "prospect" then different paragraphs will return with a different table. Is this possible? > { IF "{ MERGEFIELD type }" = "lead" "Thank you for your interest." "" } > Look up IF field in help. The braces cannot be typed in. You have to use [quoted text clipped - 10 lines] > > > > Is something like this possible Yes, although I would start storing alternatives as AutoText and using AutoText fields. 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! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. > What about doing this with idea with and entire letter. Anotherwords, if > "lead" then the letter (2 - 3 paragraphs and maybe even a table will [quoted text clipped - 19 lines] >> > >> > Is something like this possible Ok...looks like I have some learning to do here. I will try to figure that out > Yes, although I would start storing alternatives as AutoText and using > AutoText fields. [quoted text clipped - 21 lines] > >> > > >> > Is something like this possible |
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.