#1
|
|||
|
|||
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!!! |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
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. |
#4
|
||||
|
||||
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] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
formating a percentage in a Mail Merge | dkalsow | Mail Merge | 3 | 04-03-2012 03:38 PM |
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 |