Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-13-2020, 12:32 AM
swap2688 swap2688 is offline Word Mailing - conditionally adding information Windows 7 32bit Word Mailing - conditionally adding information Office 2013
Novice
Word Mailing - conditionally adding information
 
Join Date: Jun 2020
Posts: 7
swap2688 is on a distinguished road
Default Word Mailing - conditionally adding information

I have the following result table in excel where compulsory subjects are (Science & maths) and (English & Marathi) are two optional subjects
Seat No Science Maths English Marathi
1 23 25 30 #
2 26 24 # 30

now in word mailing, i have the following table
Seat No. Course Overall


<<Seat_No>> <<Subject>> <<Marks>>

Here if the student has selected optional subject English than automatically the subject English should come and corresponding marks and vice versa for Marathi.
So is there a way to do this in the mailing.
thank you.

Last edited by Charles Kenyon; 06-20-2020 at 09:37 AM. Reason: add info to title
Reply With Quote
  #2  
Old 06-13-2020, 01:59 AM
macropod's Avatar
macropod macropod is offline Word Mailing - conditionally adding information Windows 7 64bit Word Mailing - conditionally adding information Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Try employing an IF test. For example:
{MERGEFIELD Seat_No} Science: {MERGEFIELD Science}
{MERGEFIELD Seat_No} Maths: {MERGEFIELD Maths}
{MERGEFIELD Seat_No} {IF{MERGEFIELD English}= "#" "Marathi: {MERGEFIELD Marathi}" "English: {MERGEFIELD English}"}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 06-13-2020, 10:38 AM
swap2688 swap2688 is offline Word Mailing - conditionally adding information Windows 7 32bit Word Mailing - conditionally adding information Office 2013
Novice
Word Mailing - conditionally adding information
 
Join Date: Jun 2020
Posts: 7
swap2688 is on a distinguished road
Default

how to do it for the following
Say there are three 3 optional papers

O7 O8 O9
Eco # # 10
Pol 12 # #
Psy # 13 #

=IF(AND(J4="#",K4="#"),"Psy",IF(J4="#","Pol","Eco" ))

how to use "AND" in word mail merger.
thank you
Reply With Quote
  #4  
Old 06-13-2020, 03:56 PM
macropod's Avatar
macropod macropod is offline Word Mailing - conditionally adding information Windows 7 64bit Word Mailing - conditionally adding information Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

You'd use an IF test for each option:
{IF{MERGEFIELD Eco}<> "#" "Eco: {MERGEFIELD Eco}"}{IF{MERGEFIELD Pol}<> "#" Pol: {MERGEFIELD Pol}{IF{MERGEFIELD Psy}<> "#" Psy: {MERGEFIELD Psy}

You can't use the AND test that way.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Mailing - conditionally adding information “Mailing” in the PowerPoint (same as in Word), Jamal NUMAN PowerPoint 5 03-20-2018 12:14 AM
Word Mailing - conditionally adding information word mailing emtmike Word 1 10-09-2012 12:23 AM
Word Mailing - conditionally adding information Mailing: Reading values from Excel to Word Jamal NUMAN Excel 9 09-02-2011 02:08 AM
Word Mailing - conditionally adding information Bulk E-Mailing AwesomeOpportunities Outlook 1 07-25-2010 05:08 PM
Problem with mailing in word gfr Word 0 03-17-2010 05:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:45 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