#1
|
|||
|
|||
Conditional merge fields in mail merge
Hi,
I would like to set-up a mail merge to send people information about appointments they're meant to attend. Problem is, there can be up to 3 dates located in 3 different fields of the datasource (if the appointments have been re-arranged) Is there a way I can have a condition to select the last appointment arranged? Also, there are specific time and venue fields for each of the 3 appointment times, so I'd need to make sure the correct ones, matching the correct appointment. Hope I'm making sense! Thanks Aude |
#2
|
||||
|
||||
Hi Aude,
You can use Word's Catalogue/Directory Mailmerge facility for this (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. For a recent, worked example, see the attachment to post #13 at: https://www.msofficeforums.com/mail-...nt-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=5aedc...615E886B%21111
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail merge number fields outputting inconsistently | rekcots | Mail Merge | 2 | 05-18-2011 06:32 AM |
Mail Merge truncating 'some' of the text fields......Not sure what to do | sssb2000 | Mail Merge | 5 | 09-26-2010 09:40 AM |
Mail Merge Fitting Text to Fields | frnk4760 | Mail Merge | 1 | 05-18-2010 04:51 PM |
Word not highlighting conditional Merge fields | Dunce | Mail Merge | 0 | 02-15-2010 05:44 AM |
Paragraph Breaks In Mail Merge Fields | SamuelT | Mail Merge | 0 | 09-25-2008 06:38 AM |