Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-03-2011, 02:42 AM
Keith Keith is offline New to mail merge help please Windows 7 64bit New to mail merge help please Office 2010 64bit
Novice
New to mail merge help please
 
Join Date: Nov 2011
Posts: 3
Keith is on a distinguished road
Default New to mail merge help please

I am trying to set up a mail merge whereby I have different addresses to mail to and I would like to be able to choose from different paragraphs to put into the main body of the letter, rather than just have a standard letter with only the name and address being different. Is this possible and how do I set this up. Thanks for any help
Reply With Quote
  #2  
Old 11-03-2011, 03:21 AM
macropod's Avatar
macropod macropod is offline New to mail merge help please Windows 7 64bit New to mail merge help please Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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 Keith,

That's certainly possible, but it's not a trivial exercise. And, rather than having it interactive, you might find it best to add one or more columns to your datafile to indicate which variants to use. You can then use an IF test in the mailmerge main document to vary the output. A field for the IF tests might be coded along the lines of:
{IF«Var1»= "A" "Text for variant A"}
{IF«Var1»= "B" "Text for variant B"}
{IF«Var1»= "C" "Text for variant C"}
{IF«Var1»= "" "Default Text"}
where 'Var1' is the name of the variables mergefield.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. Likewise, you can't type or copy & paste the chevrons (ie '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar. Also, the IF tests don't all have to go on separate lines - I just laid them out that way for clarity.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-03-2011, 03:56 AM
Keith Keith is offline New to mail merge help please Windows 7 64bit New to mail merge help please Office 2010 64bit
Novice
New to mail merge help please
 
Join Date: Nov 2011
Posts: 3
Keith is on a distinguished road
Default

Thanks Paul, thats very helpful.

Cheers
Keith
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
New to mail merge help please Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM
Mail Merge nonworduser Mail Merge 0 08-24-2010 02:28 PM
Mail Merge help aman Mail Merge 0 05-07-2010 03:38 AM
New to mail merge help please mail merge Anthony Outlook 1 09-29-2009 06:09 PM
Mail Merge Mohanss82 Mail Merge 0 01-21-2009 12:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:31 AM.


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