Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-05-2019, 03:41 PM
SCOATS SCOATS is offline Multiple Conditional formating within MS Mail Merge from Excel Windows 10 Multiple Conditional formating within MS Mail Merge from Excel Office 2013
Novice
Multiple Conditional formating within MS Mail Merge from Excel
 
Join Date: Jun 2019
Posts: 2
SCOATS is on a distinguished road
Default Multiple Conditional formating within MS Mail Merge from Excel

I have a Word template document which has been giving me headaches. The problem is that the software that downloads a list of names, addresses, etc., doesn't combine name formats. I have attached a sample of the Excel spreadsheet. The fields that I need are are follows and explained:



Prefix - Primary Donor Prefix
Gname - Primary Donor First Name
LName - Primary Donor Last Name
Suffix - Primary Donor Suffix
Sprefix - Spouse Donor Prefix
SGname - Spouse Name
SLName - Spouse Last Name

Desig By
P - Single Membership
B - Joint Membership

PGender
M=Male
F=Female

Since some primary members are female, it complicates the merge somewhat.

So, if their membership is single, I just want their primary prefix, name, etc..."Mr. John Doe" and it doesn't matter what their gender is; however, if the primary donor = PGender Female (F) and have joint membership (B) then it must read: "Mrs. Jane and Mr. John Doe".

This used to be run through Access, then Excel, so we are trying to streamline the process of this mail merge. The coding in Access is not working in Word; however, it may be that I am not nesting it properly: =UCase((IIf(IsNull([PREFIX]),[GNAME] & " " & [MIDDLE_NAME] & " " & [LNAME] & [SUFFIX],(IIf([PGENDER]='M' And [DESIG BY]='B',[PREFIX] & ' and ' & [SPREFIX] & ' ' & [GNAME] & " " & [MIDDLE_NAME] & " " & [LNAME],[PREFIX] & ' ' & [GNAME] & ' ' & [MIDDLE_NAME] & " " & [LNAME])))))

Any help would be very much appreciated.

Thank you!!!
Attached Files
File Type: xlsx Mail Merge Data List Sample.xlsx (8.9 KB, 6 views)
Reply With Quote
  #2  
Old 06-05-2019, 05:48 PM
macropod's Avatar
macropod macropod is offline Multiple Conditional formating within MS Mail Merge from Excel Windows 7 64bit Multiple Conditional formating within MS Mail Merge from Excel 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

See Conditionally Merge Spouse Data in the Mailmerge Tips & Tricks 'Sticky' thread at the top of this forum. Although the field coding there doesn't specifically address the honorifics issue, it could easily be extended to do so. There is also no need to output the data to Excel before merging - it can be done just as easily using the Access database.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 06-05-2019, 06:44 PM
SCOATS SCOATS is offline Multiple Conditional formating within MS Mail Merge from Excel Windows 10 Multiple Conditional formating within MS Mail Merge from Excel Office 2013
Novice
Multiple Conditional formating within MS Mail Merge from Excel
 
Join Date: Jun 2019
Posts: 2
SCOATS is on a distinguished road
Default

Paul,

Thank you for your reply. We are moving away from Access due to the employee who will be merging the files is unfamiliar with it, and we think this would be easier for her. I will check out the site you mentioned.

Thanks again.
Reply With Quote
  #4  
Old 06-05-2019, 06:55 PM
macropod's Avatar
macropod macropod is offline Multiple Conditional formating within MS Mail Merge from Excel Windows 7 64bit Multiple Conditional formating within MS Mail Merge from Excel 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

Whoever is doing the mailmerge doesn't need any familiarity with Access or Excel. The process for doing it is identical and, from the standpoint of someone using Word, they don't even need to know what the data source is.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Conditional formating within MS Mail Merge from Excel Mail Merge: Using One Excel File with Multiple Sheets Townshend Mail Merge 19 06-25-2021 12:39 AM
I know nothing about mail merge, but need help with conditional statements briyosa Word 1 03-27-2017 10:17 PM
Multiple Conditional formating within MS Mail Merge from Excel formating a percentage in a Mail Merge dkalsow Mail Merge 3 04-03-2012 03:38 PM
Multiple Conditional formating within MS Mail Merge from Excel Conditional merge fields in mail merge Aude Mail Merge 1 01-06-2012 07:38 PM
Formating in Mail Merge roshagc3 Outlook 0 12-15-2009 12:20 AM

Other Forums: Access Forums

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


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