Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-06-2012, 06:17 AM
Aude Aude is offline Conditional merge fields in mail merge Windows XP Conditional merge fields in mail merge Office 2007
Novice
Conditional merge fields in mail merge
 
Join Date: Jan 2012
Posts: 8
Aude is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 01-06-2012, 07:38 PM
macropod's Avatar
macropod macropod is offline Conditional merge fields in mail merge Windows 7 64bit Conditional merge fields in mail merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,213
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional merge fields in mail merge Mail merge number fields outputting inconsistently rekcots Mail Merge 2 05-18-2011 06:32 AM
Conditional merge fields in mail merge 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 11:23 PM.


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