Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-26-2012, 10:02 PM
macropod's Avatar
macropod macropod is offline Making a template Windows 7 64bit Making a template Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,512
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #2  
Old 01-27-2012, 07:33 AM
mitch236 mitch236 is offline Making a template Windows XP Making a template Office 2007
Novice
Making a template
 
Join Date: Jan 2012
Posts: 3
mitch236 is on a distinguished road
Default

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?
Reply With Quote
Reply



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 a template making an email look like its been sent already monkeytennis Outlook 1 08-14-2010 09:18 AM
Making a template 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:05 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft