![]() |
|
|
|
#1
|
||||
|
||||
|
Hi Mitch,
Presumably, you're storing all the client data in a database or, perhaps, an Excel workbook. In that case, you could use Word's Catalogue/Directory Mailmerge facility for the letter generation (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at: http://windowssecrets.com/forums/sho...ngs-(2000-2010) or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it. You could enhance the tutorial's examples with ASK/FILLIN fields that provide prompts for anything additional that is to be input at the time, including the triggering of the inclusion of additional boilerplate text. For a recent, worked example, see the attachment to post #13 at: https://www.msofficeforums.com/mail-merge/9180-mail-merge-duplicate-names-but-different-dollar.html Alternatively, you may want to try the Many to One utility on the MergeTools Add-in that you can download from the following page of Doug Robbins' Windows Live SkyDrive: https://skydrive.live.com/?cid=5aedcb43615e886b#cid=5AEDCB43615E886B&id=5AED CB43615E886B%21111 Be warned: unlike an ordinary mailmerge, none of this is simple where the potential exists for each client to have multiple records that have to be incorpprated into the same letter.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
#2
|
|||
|
|||
|
We don't keep a MS compatible database of patient info. But that part doesn't really matter. What I want is a way to build a document that would allow for "click and add" segments of verbage. Something like:
Dear Mr. Jones, Thank you for your visit. Your last colonoscopy was performed by Dr. Smith on 1/1/02. Your next colonoscopy should be performed by 1/1/12 or sooner if your specialist requests. Please make arrangements with Dr. Smith to complete this vital screening test. I have included the contact information for your convenience. Dr. Smith (111) 555-1212 From the above example we would need to be able to insert a text box that had the outline for the paragraph and have selectable fields for Dr. Smith's name and info, another selectable field for date of last service and next service. Is this easily possible? |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Creating document from template but macros are still linked to template | webharvest | Word | 0 | 07-16-2011 09:34 AM |
making an email look like its been sent already
|
monkeytennis | Outlook | 1 | 08-14-2010 09:18 AM |
Help making a coupon
|
mindy sue | Office | 1 | 01-23-2010 02:23 AM |
| Making template that is not printable | Askaleto | Word | 0 | 10-14-2009 11:45 AM |
| Making many documents one | shikaku | Word | 0 | 04-07-2008 07:12 AM |